Newbie MySQL Question; INSERTS

[Anon]

I have a table with a standard auto numbered primary key, I was wondering if there's any way for MySQL to return the id number of the record it inserts after inserting it (if that made any sense) without running another query.

I'm attempting to insert records into two tables, and the second insert requires the id from the first insert - how do I obtain this?

Thanks for your time.

[tomhath]

It's explained pretty well in the manual. While you're there you would do yourself a favor by reading about the other mysql functions available in php:

http://www.phpbuilder.com/manual/function.mysql-insert-id.php

[Anon]

mysql_query ("INSERT INTO table SET username='$username',password='$password'");
$id = mysql_insert_id ();