Get ID of record inserted

How would I go about getting the id (auto_increment field) from the record I just inserted into the DB?

MySQL?

$result = mysql_query("SELECT * from tablename", $db);

$lastid = mysql_insert_id($result);

yes, MySQL sorry forgot that.

Oh yeah, guess this would only work with an update statement:
$result = mysql_query(INSERT into tablename (name) VALUES ('something')", $db);

$lastid = mysql_insert_id($result);

actually the mysql_insert_id function does not take any input so you will get an error with:

$lastid = mysql_insert_id($result);

what you need to use is:

$lastid = mysql_insert_id();

this will return the id of the last inserted record and set $lastid equal to the auto increment id.

Boy sure hope he might have found an answer in the two years since this question was asked, looks like someone needs a hobby!