i think you're use of " instead of ' is what is giving you errors. hth jeff "Paul Ihrig" <pihrig@columb To: <php-db@lists.php.net> us.rr.com> cc: Subject: RE: date formatting... help 05/16/2003 09:22 AM Jeffery like this? $query_rsViewNews = "SELECT newsId, newsAuthor, newsTitle, DATE_FORMAT("newsDate", "%M %e, %Y") AS Fdate, newsDate, newsDescription FROM news ORDER BY newsDate DESC"; which throughs errors.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php