[SOLVED] quickly query a record ased on a primary key that you dont yet know

[jeff5656]

Ok, I create a new record, and the primary key automatically auto-increments:

 

$query = "INSERT INTO icu (id_incr, rm_loc, pod, vent, vent_exp, ventever,resident, patient, mrn, pulmonologist, age, race, gender, rcf_date, rcf_date2, dx, pmhx, problist, problist_date, todo, todo_date, comments, comments_date, code, allergy, signoff_status)

VALUES('','$rm_loc', '$pod', '$vent', '$vent_exp','$ventever','$resident','$patient', '$mrn', '$pulmonologist','$age', '$race', '$gender', '$rcf_date', '$rcf_date2', '$dx', '$pmhx', '$problist', '$problist_date', '$todo', '$todo_date', '$comments', '$comments_date','$code', '$allergy','a')";

mysql_query($query) or die(mysql_error());

 

After I run these lines, what is the correct code now to get the value of the id_incr?

[Daniel0]

You can run the query LAST_INSERT_ID() or use PHP's mysql_insert_id

[jeff5656]

You mean after the query I do:

 

$pt_id = last_insert_id();

 

or do I have to SELECT last_insert_id();

 

ugh. sorry - I m not very good with query syntax yet!

[jeff5656]

Ok I tried this and it seems to wrk.  Thanks

 

$pt_id =  mysql_insert_id();