Get ID from database.

[foxroberts]

Hi.

I add stuff to a database. The ID is set automatic.
How can I get the ID of the stuff I just put in there?

Can I ask the database for the last ID that were
given away?

Thanks alot!

Fox

[Mega]

Originally posted by foxroberts
Hi.

I add stuff to a database. The ID is set automatic.
How can I get the ID of the stuff I just put in there?

Can I ask the database for the last ID that were
given away?

Thanks alot!

Fox

SELECT MAX(id) FROM table

$row = mysql_fetch_array( $result );

echo $row[0];

[sunit_modi]

Hi,

Im not sure what Mega meant with his statement since my brain is not working at the moment but i had a simular problem last year.

You said that your database table had a field that was automatic (qoute - "The ID is set automatic"), did you mean it had a field that was auto-incrementing, if so, you can use a mysql statement after inserting your data called mysql_insert_id().

Basically if you have the following :

$link = mysql_connect ("hostname, username, password");
$statement = "insert into blah blah blah";
$execute = mysql_query($statement);
$insert_value = mysql_insert_id($link);

the value in the $insert_value variable will be the id number of the last autoincremeted value in the table.

Since this I done this last year im sure that any conventions have changed, but hey it worked for me.

Good luck.

Sunit
😃 😃 😃 😃 😃