How To Get The First Row, and ORDER BY date...

[phpSensei]

if I wanted to get one row from a table, but I wanted the row that is the most up to date, would I have to do this?

 

$sql=mysql_query("SELECT * FROM table ORDER BY date ASC") // The Newest Record
$row=mysql_fetch_assoc($sql);

[Zane]

To get only the first row you'd do

SELECT * FROM table ORDER BY date LIMIT 1;

 

 

[phpSensei]

Yeah But i want the latest date in that row also.

[Barand]

to get newest/latest

 

SELECT * FROM table ORDER BY date DESC LIMIT 1;