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