1064 - You have an error in your SQL syntax;

[vishnu]

Hi,

 

 

I have an error the following lines please help me.

 

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 'select o.orders_id, o.orders_status, o.date_purchased, o.delivery_name, ot.text ' at line 1

 

select count(select o.orders_id, o.orders_status, o.date_purchased, o.delivery_name, ot.text as order_total, s.orders_status_name from orders o left join orders_total ot on (o.orders_id = ot.orders_id) left join orders_status s on (o.orders_status = s.orders_status_id and s.language_id = \'1\') where o.customers_id = \'2\' and ot.class = \'ot_total\' order by orders_id DESC) as total

 

[TEP STOP]

 

 

please reply me.

[Jack_mcs]

These slashes shouldn't be in the code

language_id = \'1\') where o.customers_id = \'2\' and ot.class = \'ot_total\'

 

Jack