Re: Displaying MySQL database with DATE_FORMAT

2001-06-01 Thread Eric Fitzgerald
%D %Y') AS FormattedEventStartDate, TIME_FORMAT(EventStartTime, '%r') AS FormattedEventStartTime FROM comcal2001 WHERE blah - Original Message - From: "Tim Thorburn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 12:08 PM Subject: Displaying M

Displaying MySQL database with DATE_FORMAT

2001-06-01 Thread Tim Thorburn
Hi, I've developed a simple search engine for a site I'm working on. Its purpose is to display community events based on the users input criteria. The problem is, if I use the DATE_FORMAT command to alter the appearance of the events dates and times - then MySQL begins at the top of the list