Get last record from database

Question

How can I get the last entry in the last DATE field from a MySQL database using PHP?

The rows will not match the date, so I cannot just take the first or last row.

Answer 1

You want ORDER BY , and possibly LIMIT .

$query = 'SELECT * FROM `table` ORDER BY `date` DESC LIMIT 1';

Answer 2

SELECT * FROM [Table] ORDER BY [dateColumn] DESC

If you want only the first line:

In T-SQL:

SELECT TOP(1) * FROM [Table] ORDER BY [dateColumn] DESC

In MySQL:

SELECT * FROM `Table` ORDER BY `dateColumn` DESC LIMIT 1

Answer 3

LIMIT ORDER BY.

:

SELECT * FROM entries ORDER BY timestamp DESC LIMIT 1

Answer 4

, ? , , , . , ?

SELECT * FROM table ORDER BY recno DESC LIMIT 1;

SELECT * FROM table ORDER BY date_revised DESC LIMIT 1;

Thus, the PHP call will look like this:

$result = mysql_query("SELECT * FROM table ORDER BY date_revised DESC LIMIT 1");

- Nicholas