Thanks this works!!!! the difference was the 'AS datefield' what is this bit doing? I searched for AS (in the SELECT description in my book) but it does not mention it; though I have seen it in examples. I like to understand why I use the code I do...
I looked at http://www.mysql.com/ but can find no mention. Am I searching for the wrong thing? I searched for AS in the documentation thanks again Jules > > You may want to try: > > $result = mysql_query("SELECT title, description, url, author, > date_format(datefield, '%M %D %Y') AS datefield FROM documents"); > --------------------------------------------------------------------- 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