Hi there, I seem to be having a problem retrieving the last inserted ID for a table.
The query I am using is as follows: mysql> select distinct LAST_INSERT_ID() as LastID from listings; +--------+ | LastID | +--------+ | 3575 | +--------+ 1 row in set (0.00 sec) However, when I run this from my PHP script, I get a value of 0. Any clues as to how to resolve this? Thanks! -Erich- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
