Error in MysqlQuery

[vgshri]

Hi,


I have an MYSQL Query , that excetues in the MYSQL Database, but it shows an error while running that query in PHP. The Query is,

SELECT a.stock_item_code AS PRODUCT_CODE,a.stock_desc AS DESCRIPTION,sum(b.qty_ordered) AS STOCK_DRAWN,a.replenish_amt as INTO_STOCK,a.intial_stock_amt AS BALANCE_B_FWD,a.critical_level AS REORDER_LEVEL,sum (a.intial_stock_amt+a.replenish_amt-0) as BALANCE_C_FWD FROM cf_stock a LEFT JOIN cf_pcorder b ON a.stock_id = b.stock_id GROUP BY a.stock_item_code


The error occuring while running the query in PHP,

It shows an 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 '(a.intial_stock_amt+a.replenish_amt-0) as BALANCE_C_FWD FROM cf_stock a LEFT JOI' at line 1.

Thanks in Advance.

[PEB]

Hi,


I have an MYSQL Query , that excetues in the MYSQL Database, but it shows an error while running that query in PHP. The Query is,

SELECT a.stock_item_code AS PRODUCT_CODE,a.stock_desc AS DESCRIPTION,sum(b.qty_ordered) AS STOCK_DRAWN,a.replenish_amt as INTO_STOCK,a.intial_stock_amt AS BALANCE_B_FWD,a.critical_level AS REORDER_LEVEL,sum (a.intial_stock_amt+a.replenish_amt-0) as BALANCE_C_FWD FROM cf_stock a LEFT JOIN cf_pcorder b ON a.stock_id = b.stock_id GROUP BY a.stock_item_code


The error occuring while running the query in PHP,

It shows an 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 '(a.intial_stock_amt+a.replenish_amt-0) as BALANCE_C_FWD FROM cf_stock a LEFT JOI' at line 1.

Thanks in Advance.

Hi,

What is the goal to substract zero in your expression?

And if you put ; at the end of your SQL?

:)