Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1064: 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 '4
group by ptc.products_id
order by ptc.products_' at line 27] in EXECUTE("
select COUNT(*) as prodCount
from (
select *
from
(
select distinct b.products_id, products_image, products_name, product_image_thumbnail, categories_parent_name, categories_parent_id,
categories_name, b.categories_id, description_name,
description,
products_code, products_price,
c.dolar, c.persentage, c.status,
if(status = '+', products_price + (if(dolar <> null, dolar, (persentage * products_price)) ) ,
products_price - (if(dolar <> null, dolar, (persentage * products_price)) ) )
as new_product_price
from (
select p.products_image, pd.prod in /home/flowerad/public_html/lib/sd_m/dbconn/adodb/adodb-exceptions.inc.php on line 78
|
