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..) > > > > 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
