Find Last Entry In Mysql Database

This Page Contains information about Find Last Entry In Mysql Database By normas in category MYSQL with 1 Replies. [2299], Last Updated: Mon Jun 24, 2024

normas

Thu Sep 24, 2009

1 Comments

371 Visits

i have been beating my head up against the wall,

you see, i have this script i am making, and i have a table with a column called studentId and each student has a unique id. so now i want to find last entry in mysql database.Choosing last entry of MySQL table should be easy i know, but i can't find a query.

as each student signs up, it creates an incremental ID, that field is called studentId, do you know how i can get the last row from mysql database using php?

webune

Thu Sep 24, 2009

what you need is to add the SORT by in your query for example like this: $Query = "SELECT StudentName from StudentsTable ORDER BY studentId DESC LIMIT 0,1"; ok, if you run that query, its telling mysql to SELECT StudentName from the StudentsTable.. the key component is the ORDER BY - i want to make it descenting, so i put DESC and... since i only want the only the last one, i use LIMIT 0,1 hope that helps

https://www.webune.com/forums/find-last-entry-in-mysql-database.html

Illegal Mix Of Collations How To Fix

Find Last Entry In Mysql Database

Related Pages