MySQL Query Executes in PHPMyAdmin but NOT PHP

Quite simply, I just finished my system and I get to the last part and everything doesn't work. How typical!

So my PHP script generates the following query as an example. HOWEVER, the query it generates gives a syntax error, but it executes perfectly fine when copy and pasted into PHPMyAdmin.

Very Tedious and need some help.

This is the PHP code that is used to generate the query:

PHP Code:
$OrderQuery = "BEGIN;
";

//(THIS PART IS IN A LOOP)

$OrderQuery .= "UPDATE `Product`
SET PRODUCT_QTY = '$NewQTY'
WHERE PRODUCT_ID = '$ItemID';
";
//(END LOOP PART)

$OrderQuery .= "
UPDATE `Customer`
SET CUST_ACTIVEORDER = NULL
WHERE CUST_ID = '$C_ID';

SET @date = now();



UPDATE `Order`
SET ORDER_STATUS = '$completeString'
WHERE ORDER_ID = '$C_AO';

UPDATE `Order`
SET ORDER_DATE = @date
WHERE ORDER_ID = '$C_AO';

UPDATE `Order`
SET ORDER_INFO = '$OrderInfo'
WHERE ORDER_ID = '$C_AO';

";

$OrderQuery .= " COMMIT;";


Now, the query it generates, and works fine when copy and pasted into PHPMyAdmin is:

BEGIN; UPDATE `Product` SET PRODUCT_QTY = '33' WHERE PRODUCT_ID = '3'; UPDATE `Product` SET PRODUCT_QTY = '77' WHERE PRODUCT_ID = '1'; UPDATE `Product` SET PRODUCT_QTY = '25' WHERE PRODUCT_ID = '4'; UPDATE `Customer` SET CUST_ACTIVEORDER = NULL WHERE CUST_ID = '1'; SET @date = now(); UPDATE `Order` SET ORDER_STATUS = 'Complete' WHERE ORDER_ID = '18'; UPDATE `Order` SET ORDER_DATE = @date WHERE ORDER_ID = '18'; UPDATE `Order` SET ORDER_INFO = ' ' WHERE ORDER_ID = '18'; COMMIT;

Results from PHPMyAdmin:


BEGIN ;# MySQL returned an empty result set (i.e. zero rows).
UPDATE `Product` SET PRODUCT_QTY = '33' WHERE PRODUCT_ID = '3';# Affected rows: 1
UPDATE `Product` SET PRODUCT_QTY = '77' WHERE PRODUCT_ID = '1';# Affected rows: 1
UPDATE `Product` SET PRODUCT_QTY = '25' WHERE PRODUCT_ID = '4';# Affected rows: 1
UPDATE `Customer` SET CUST_ACTIVEORDER = NULL WHERE CUST_ID = '1';# Affected rows: 1
SET @date = now( ) ;# MySQL returned an empty result set (i.e. zero rows).
UPDATE `Order` SET ORDER_STATUS = 'Complete' WHERE ORDER_ID = '18';# Affected rows: 1
UPDATE `Order` SET ORDER_DATE = @date WHERE ORDER_ID = '18';# Affected rows: 1
UPDATE `Order` SET ORDER_INFO = ' ' WHERE ORDER_ID = '18';# Affected rows: 1
COMMIT ;# MySQL returned an empty result set (i.e. zero rows).

Error recieved from PHP:

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 'UPDATE `Product` SET PRODUCT_QTY = '33' WHERE PRODUC' at line 2

EDIT: used a better/new query.

 

Apparently it doesn't accept semicolon splitting. Does it work if you run each line separately ?