SQL query un mysql_query

[Pieduriens]

Labvakar.

Galīgi netieku gudrs.

 

Vēlos izpildīt kveriju caur php:

 

Kverijs: 

$vouc = 'xxx';
$sql =           "
		SET FOREIGN_KEY_CHECKS=0;
		INSERT INTO salesrule (name)VALUES('$vouc');
		SET FOREIGN_KEY_CHECKS=1;
		";
mysql_query($sql) or die (mysql_error());

Caur phpmyadmin SQL kverijs izpildās.

Caur PHP saņemu kļūdu: 

 

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 'INSERT INTO salesrule (name)VALUES('xxx'); SET FOREIGN_KEY_CHECKS=1' at line 2

 

Ticu, ka risinājums ir elementāri elementārs, taču zinu, ka svaiga acs to ieraudzīs.

Paldies :)

[aaxc]

Tu pameegjinaaji izpildiit 3 dazhaadus querijus?

[Pieduriens]

Tu pameegjinaaji izpildiit 3 dazhaadus querijus?

Fantastika!

Paldies par hint ;)

[Kavacky]

Multi query.