> #2 All I have read on the web/books suggests that this is what to do
> $result = mysql_query ("SELECT title, description, url, author,
> date_format(datefield, %M %D %Y') FROM documents");
>
> This just leaves out all dates.
You may want to try:
$result = mysql_query("SELECT title, description, url, author,
date_format(datefield, '%M %D %Y') AS datefield FROM documents");
You can also do
$result = mysql_query("SELECT title, description, url, author,
unix_timestamp(datefield) AS datefield FROM documents");
then use php's date() function.
---------------------------------------------------------------------
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
