note 32349 added to function.mysql-query
| From: | m dot marrink at tiscali dot nl | Date: | Sat, 24 May 2003 15:33:28 +0000 |
| Subject: | note 32349 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-48945@lists.php.net to get a copy of this message | ||
Multiple querys separated by ; will not always work.
The following query does not work if passed on to mysql_query as a single string.
CREATE TEMPORARY TABLE tmp (field1 INT(11) NOT NULL); LOCK TABLES sometable READ ; .....
It fails on the LOCK TABLES part.
You will need to do each query in a separate string in order to get them to work.
UNLOCK TABLES has the same problem and possibly others too.
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+32349
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+32349&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+32349&report=yes