hello just call: mysql_insert_id();
right after you execute a insert statement Foong "Ben Cheng" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > If I have a MySQL table with an auto-incrementing ID field, is there an > easy way to retrieve the new ID after I insert a new row into the > table? For example, if I insert a row into a table with ID, Title, & > Content fields, is there a way I can get the ID value without doing a > separate select where the Title & Content fields are equal to the > values I just inserted? > > -Ben > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
