How to get last inserted row

[geekisthenewsexy]

hi there,

so okay i have a table named course which has 2 fields.

 

c_id and c_name

c_id here isn't unique but is indexed.

 

okay,my problem is how to get the last inserted row in this table right after a record has been inserted.

i was thinking i'd do a little query and then echo the results back to where the user fills up a form with c_id and c_name fields..

so is there a way to do this?like getting all values from the last inserted row?

 

[trq]

mysql_insert_id

[Adam]

That won't work here given that the "c_id" field isn't an auto incremented field.

[Pawn]

Bit of a hack, but...

 

Add a table column "c_created", type TIMESTAMP, default CURRENT_TIMESTAMP. Select as follows:

 

$sql = "SELECT * FROM courses ORDER BY c_created DESC LIMIT 1";

Of course, if two rows are inserted in the same second you have a problem.

[PFMaBiSmAd]

If you want to get the id of the row that was just inserted by the current visitor in your script, you need to add an auto-increment field to your table.

[geekisthenewsexy]

hey guys, thanks for helping..

i have added an auto-increment on c_id field but i didn't make it unique..

iv'e used this one mysql_insert_id().

thanks!