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 contains the dates.
...and add a clause to take care of the temporal constraint, eg WHERE dateColNm > NOW() (depending upon the format of the date column) Recommend a quick look at the manual - it has a quick intro/tutorial chapter that covers this ground quite neatly! Regards, =dn > > 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 > > --------------------------------------------------------------------- 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