quering for the greatest value

[mojodojo]

I have a forum type of page that stores comments, who left the post, and time and date. Is there a query that will select a record with a greatest value. For example, i want a query that will result in only the last post that was made. And I want to use the date to determine this.

[leatherback]

How about:

Select * from table order by date descending limit 0 1

[stolzyboy]

it would be easier to use an id field that is auto_incremented then you just select all sort asc or desc, can't remember right now which one will work in your situation, then just limit the query by one

[mojodojo]

I made the table before I knew about auto_increment. The thing has more than 62000 records now. so adding one now might not work well. Thanks for the answers though. I will use them.