Input record and view details

[Rmeeuwsen]

I'm using a form to register users and immediately after the registration I want to go to a detail page that shows the users details. How do I create a query to do this in php?

Kind regards,

Robin Meeuwsen

[Günter_Schenk]

Hi,

you can retrieve the new record this way:

SELECT * FROM user_table ORDER BY id DESC LIMIT 1

- "id" is your unique numeric autoincrement field
- DESC means "in descending order"
- LIMIT 1 means "retrieve just one record"