> I am doing this using mySQlGui 1.7.5-2 on Win 2000 > Professional.
>From what I understand last_insert_id() can only be used on the same connection as the insert. I'm guessing after every query mysqlgui runs it disconnects, therefore killing last_insert_id(). -Jason Yates --------------------------------------------------------------------- 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