On Monday, 29. July 2002 06:33, databarn wrote: Hi, > > E.G., $qry=$qry.";select LAST_INSERT_ID();" will blow up on me every time > I've evaluated $qry, and it works just fine until I append the piece that > should let me recover the auto increment value that was created during the > insert process.
Fortunately its not possible to combine multiple commands in a single query (that would be a security hole). You have to send two queries instead, or you can use the php function mysql_insert_id after executing the 1st query. > I'm using, according to phpinfo(), MySQL 3.23.32 and PHP 4.0.5 on Win2K > with IIS 5.0. I recommend to upgrate your MySQL and PHP-Version. Regards Georg mysql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php