Re: [PHP-DB] Batch queries in the same mysql_query()

I'm trying to execute multiple queries using mysql_query() function and I'm getting an error to check SQL syntax. My PHP code looks like: You cannot execute multiple queries at once using mysql_query(). If you are using PHP 5.x and MySQL 4.1.x, there are new functions, one of which does

[PHP-DB] Batch queries in the same mysql_query()

Hi, I'm trying to execute multiple queries using mysql_query() function and I'm getting an error to check SQL syntax. My PHP code looks like: //- $sql=select x from y ; insert into y values ( 1, 2 ); mysql_query( $sql ) or die( mysql_error() );