[SOLVED] [Q] PHP and MYSQL

[Minase]

hy there i have some querys entering data into a table

and one column is autogenerated by sql server.it is an integrer with auto increment.

table overview

-ID

-Name

-Data

 

my query insert information in Name and Data the ID is autogenerated,but after i enter Name and Data i need to get the ID of what was inserted.

any typs?

thanks

[monkeypaw201]

well, you could always go back and re-query for the latest entry that matches the name & data you just entered

 

$result= mysql_query("SELECT * FROM `table` WHERE `Name` = '$NameData' AND `Data` = '$DataData' ORDER BY `id` DESC") or die(mysql_error());
$row_result= mysql_fetch_array($result);
echo $row_result['id'];

[Minase]

so thats the only solution ? i was thinking on that but i wanted another solve.

thanks for reply

any other solve this have?

[PFMaBiSmAd]

http://us3.php.net/mysql_insert_id

[Minase]

exactly what i needed thank you