Ok, I guess I have to re-state what I needing help with. I have a database with three date fields. If I do a date_format for all three fields I get error. Example
SELECT DATE_FORMAT(DATE1, '%M %D, %Y) as DATE1, DATE_FORMAT(DATE2, '%M %D, %Y) as DATE2, DATE_FORMAT(DATE3, '%M %D, %Y) as DATE3, Groom, Bride FROM DB1; Now I am using this sql statement in a PHP page. I want to see if you can do sql statement in $myrow, but don't think you can. So I want to know if there is an easy way to do dates. Thanks if you can help or will answer. Chuck Payne Magi Design --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php