Hi, Saturday, March 27, 2004, 4:50:27 AM, you wrote: CM> I have this query to select the date from my table...
CM> SELECT DATE_FORMAT(date1, '%W %M %Y') FROM table CM> How do I know what name mysql_fetch_array assigned to the date_format ? SELECT DATE_FORMAT(date1, '%W %M %Y') AS date_formatted FROM table Then access it as date_formatted -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php