Select a newly inserted mysql record

Anon

I have a form that inserts a new record into a database (with a unique field of part_num). That works no problem. After inserting the new record however, I am trying to retrieve it from the database ("SELECT * FROM products WHERE part_num='$part_num'") and it returns an empty result. I've echoed the query and it is the correct query, with the user entered part_num, and if I go to another page and perform the same query, then it works. It seems as though it is not inserting the record before it tries to select it. Any thoughts? TIA

cordex

I hate to sound like a smartass, but where is your query run?

This will not work, for instance:

$query = mysql_query("SELECT * FROM products WHERE part_num='$part_num'");

$insertquery = mysql_query("insert query here");

$queryvalues = mysql_fetch_array($query);

I know it seems obvious, but I have been known to get ahead of myself at times or depend on a pre-defined query that no longer contains the current values.

shrug It's a place to start.

-Ben

Anon

Thanks for the reply, but I do have the insert query running before the select query.

bfinucan

Hello,
To filter query results by the autoID just generated by an INSERT statement use (assuming you're using MySQL) mysql_insert_id.

So you're query should look like this (placed after your INSERT of course):

("SELECT * FROM products WHERE part_num='" . mysql_insert_id() . "'"

This retrieves the autoID generated by the last INSERT to occur on the given page.