While we are on this subject, does anyone know how to force a comma or two in there, as in: Friday, September 5, 2003 TIA --Dave Shugarts > > right on > $query_rsViewNews = "SELECT newsId, newsAuthor, newsTitle, > DATE_FORMAT(newsDate, '%M %e, %Y') AS Fdate, newsDate, newsDescription FROM > news ORDER BY newsDate DESC"; > > makes sense.. > thanks > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php