Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Input record and view details

New Here ,
May 21, 2007 May 21, 2007
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
TOPICS
Server side applications
185
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
May 21, 2007 May 21, 2007
LATEST
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"
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines