Male shop
Junior wear shop
SITE SEARCH
Notice: Error on query....
"select p.*,b.brand_id,b.brand_name,b.discount as brandDiscount,c.discount as categoryDiscount,b.description as brand_desc,b.image,pi.product_image,po.product_option_id,po.price, po.disc_price_perc from products p inner join product_images pi on pi.product_id=p.product_id inner join brand b on b.brand_id=p.brand_id inner join categories c on c.categories_id = p.categories_id inner join product_option po on po.product_id=p.product_id where p.status='Active' and pi.default_image='Yes' and po.default_option='Yes' and pi.colour_id = po.colour_id and p.brand_id= and po.disc_price_perc > 0 order by p.product_name"
Mysql says - 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 'and po.disc_price_perc > 0 order by p.product_name' at line 1 in
/home/wwwhyped/public_html/lib/functions/mysql.php on line
67
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
/home/wwwhyped/public_html/lib/functions/mysql.php on line
73
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in
/home/wwwhyped/public_html/lib/functions/mysql.php on line
76