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