Query Last record?

[maharamDan]

Hello I have a DB with 4 fields. id title event date.

I would like to query the last record only and display it. I am using mysql and php. The trouble I am finding is how to query the last record by id?

Thanks in advance.

ake care.

 

[maharamDan]

I think I found a solution $query="select * from soft order by id DESC limit 1

Does that look ok?

 

[sleipnir214]

That's the way I would do it.




Want the best answers? Ask the best questions!

TANSTAAFL!!