Batch queries in the same mysql_query()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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() );
//-------------------------

Maybe the problem resides on the character ";", but this queries run without problems when typed on "mysql" command-line tool. So, if it works on "mysql" command line, why it doesn't work using mysql_query() ?

Any hint ?

TIA,

Denio Mariz

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux