ORDER

[natalieG]

How do set up a query so that on a date column which contains ther record date, the data
arrives last entry first?

Thanks,

Natalie;

[AndyB]

Adjust to suit ... assuming that the actual dates are yyyy-mm-dd style:
[code]$query = "SELECT * from tablename ORDER by datefieldname DESC";[/code]

That should sort by [b]latest[/b] to [b]earliest[/b] date which is what I assume you wanted.