queries ( your help appreciated)

2002-03-28 Thread David Rice
I am quite new to coding and have managed so far but, i've been havin trouble with queries. Okay well here goes, it is quite simple but i can't figure it out, and haven't found any helpfull documentation I have a mysql database, and i want to sort a table by date Where the resulting records

Re: queries ( your help appreciated)

2002-03-28 Thread Steven Hajducko
Hey David. I think this is what you want? select * from table order by date_column ASC; ( for ascending order..) select * from table order by date_column DESC; ( for descending order..) Replace 'table' with the name of your table and date_column with the name of the column that contains the

Re: queries ( your help appreciated)

2002-03-28 Thread DL Neil
David, Steven, I think this is what you want? select * from table order by date_column ASC; ( for ascending order..) select * from table order by date_column DESC; ( for descending order..) Replace 'table' with the name of your table and date_column with the name of the column that

Re: queries ( your help appreciated)

2002-03-28 Thread Steven Hajducko
D'oh. Forgot he wanted after now :) Thanks. On Thu, 2002-03-28 at 10:46, DL Neil wrote: David, Steven, I think this is what you want? select * from table order by date_column ASC; ( for ascending order..) select * from table order by date_column DESC; ( for descending order..)