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 dates. -- sh On Thu, 2002-03-28 at 10:15, David Rice wrote: > 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 will be greater than (i.e. tommorow) ttodays date > > If someone could give me an example code of how it is done, it would be much > appreciated > > thanks, > -dave > > > > _________________________________________________________________ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
