jt9d@excite.com wrote:

> Hi;
> I am using phpformgenerator and it works great, but how can I make
> mysql to sort the databased on dates. I need to make sure that the
> latest date is on top of the page.
> Thanks
> M.J
>
>
> DATE
> FLIGHT NUMBER
> TAIL NUMBER
> GATE
> DELAY
> LOG GEN
> RECALL TIME
>

first of all, I certainly hope that your field names don't include spaces. That
can be very nasty if you ever decide to move it to a real database engine.

select col1,col2... from table <where clause> order by date desc;


--
Michael Austin.