Okay, I've seen just about every question on last_insert_id(), except this one:
I am running MySQL on Win XP and when I generate a test table (test) with an AUTO_INCREMENT column (aid) and a second column (a) then use an insert statement like: INSERT INTO test (a) values (1); then: SELECT LAST_INSERT_ID(); I get a return value of 0. I considered the fact that maybe my connection is closing, but when I create the same table on a remote Linux server it returns the proper AUTO_INCREMENT ID. Is there a server variable I need to set or something that I should be looking for in order to make this work on Windows? Al Kearns, Sales Representative/WebMaster, MCP [EMAIL PROTECTED] 1-866-858-9200 --------------------------------------------------------------------- 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