<div><h4>Debug Message</h4><pre>array(2) {
  [0]=>
  string(155) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[shop_id]' at line 1"
  [1]=>
  string(66) "SELECT * FROM shop_appearance WHERE shop_appearance_id = [shop_id]"
}
</pre><pre>[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1382 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetRow] #516 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getFirstRow] #1623 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #149 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3370 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #244 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #144 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php
</pre></div><div><h4>Debug Message</h4><pre>array(2) {
  [0]=>
  string(155) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[shop_id]' at line 1"
  [1]=>
  string(80) " select  count(*) from   shop_appearance  where   shop_appearance_id = [shop_id]"
}
</pre><pre>[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #644 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getCount] #1648 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #149 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3370 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #244 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #144 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php
</pre></div><div><h4>Debug Message</h4><pre>array(2) {
  [0]=>
  string(155) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[shop_id]' at line 1"
  [1]=>
  string(80) " select  count(*) from   shop_appearance  where   shop_appearance_id = [shop_id]"
}
</pre><pre>[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #663 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getCount] #1648 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #149 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3370 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #244 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #144 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php
</pre></div><div><h4>Debug Message</h4><pre>array(2) {
  [0]=>
  string(155) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[shop_id]' at line 4"
  [1]=>
  string(261) "SELECT `ua`.`city`, `ua`.`state`, `ua`.`country`
                    FROM `shop_appearance` as `shop` 
                    LEFT JOIN `users_address` as `ua` ON `ua`.`users_id` = `shop`.`users_id`
                    WHERE `shop`.`shop_appearance_id` = [shop_id]"
}
</pre><pre>[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1330 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetArray] #1197 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetAll] #588 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getAll] #1679 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #149 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3370 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #244 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #144 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php
</pre></div><div><h4>Debug Message</h4><pre>array(2) {
  [0]=>
  string(155) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[shop_id]' at line 5"
  [1]=>
  string(433) "SELECT *,DATE_FORMAT(date_of_join,'%M %d%, %Y') as date_of_join,u.users_id as users_id, sa.shop_appearance_id as shop_appearance_id
                    from `shop_appearance` sa,`users` u 
                    left join `users_profile` up on up.users_id = u.users_id
                    left join `shop_banners` sb on sb.user_id = u.users_id
                    where u.users_id = sa.users_id and sa.shop_appearance_id = [shop_id]"
}
</pre><pre>[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1382 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetRow] #516 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getFirstRow] #675 /var/www/html/jellyfiz/includes/common_functions.inc.php
[getShopDetail] #1691 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #149 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3370 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #244 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #144 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php
</pre></div>