and if I look admin error log it will say:
Code: Select all
2012-10-01 10:24:14 - PHP Notice: Error: 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 'order WHERE customer_id = '10' AND order_status_id = '5'' at line 1<br />Error No: 1064<br />SELECT total FROM order WHERE customer_id = '10' AND order_status_id = '5' in /home/myshop/public_html/system/database/mysql.php on line 49