[nova912]

This is a mysql heavy question but i think it has some relevance to php so ill post it here.

I have a few tables that when new data is inserted into them they will have new unique ID number generated for them by mysql... for example

INSERT INTO db_table SET id=null, name="dan", age="23"

Now in php I have always ran 2 queries, one for the insert and the other for getting the ID that mysql has set for the just inserted data. Is there a way that i can get the ID back in a single query in php, maybe like....

PHP Code:

$query='INSERT INTO db_table SET id=null, name="dan", age="23";SELECT id FROM db_table WHERE name="dan" && age="23"';

$result = mysql_query($query);

$array = mysql_fetch_array($query); 

Would $array['id'] equal the generated ID?

Is there a technique out there I am missing to do this?

I'm just wondering, trying to cut down running unnecessary queries in a script.

[Keith]

www.php.net/mysql_insert_id

PHP Code:

<?php

mysql_query( "INSERT INTO db_table ( id, name, age ) VALUES ( NULL, 'dan', '23' )";
$id = mysql_insert_id();

?>

[nova912]

lol thanks, stupidly simple.