Retrieving the last inserted value.

[markbowman]

I have created some forms to insert data into mysql and after the data has inserted I want to retrieve it in the next page.

Using this but its not working..

SELECT *
FROM products
WHERE productsid = $lastid

Anyone?

Thanks

Mark
😕

[cgraz]

I think you can accomplish this with mysql_insert_id() or LAST_INSERT_ID()

I've never used LAST_INSERT_ID() but it looks like it has potential.

Hope this helps!