The actual query is : SELECT * FROM PROFILES WHERE fname="scott" ORDER BY lastused;
The lastused field is of type date, and I want the returned result set to be ordered by that date. Thanks - Scott Carter -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 5:51 PM To: Carter, Scott; '[EMAIL PROTECTED]' Subject: Re: simple question At 17:19 -0600 11/18/02, Carter, Scott wrote: >I want to sort my results by a date that is contained in the database table >the query is performed on. The ORDER BY clause does not seem to do the >trick. How do you do this? > >Thanks - Scott Carter With ORDER BY. You'll have to provide more details so that we can see what the problem is with your query. --------------------------------------------------------------------- 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