[RESOLVED] Select maximum value

[phprooky]

Hi everyone,
I have a select to MYSLQ database where I'm trying to bring the greatest value, but I don't know how to do that, can anyone please help me?
The fields I have are:
Id autoincrement, field2 text, field 3 text, date
The way I want to do it is by bringing the last Id.
Select field2, field3, date from my_table where id=max(id);
Is it possible to do this?

[dabaR]

Select field2, field3, date from my_table order by id desc limit 1;

Hope that helps!

Dan Bernardic
http://dan.bernardic.ca

[phprooky]

Thanks a lot for your help dabaR!!!