At 9:06 -0600 11/19/02, Carter, Scott wrote:
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.
Still need more info. What dates are in the records with "scott" and
in what order are they returned?
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
