most recent entry

[weazy]

i have a database with 3 columns, two for data entry and one that is the date the data was entered. the two data entry fields are numerical.

i want to construct a query that checks for the most recent data entry and then selects the numerical data from the other two fields... thoughts, comments?

[devinemke]

SELECT * FROM table ORDER BY date DESC LIMIT 1