DATE_FORMAT

Anyone provide insight on how to retrieve * columns from a MySQL db of which includes a date field in which I want to use MySQL's DATE_FORMAT on it.

Below is an example of retrieving the date field:

SELECT DATE_FORMAT(date_column, '%a %b %w) from table

Problem is I am retrieving numerous columns and using

$row = mysql_fetch_array($result);

then echoing the results in a table

echo ($row[rundate]);

This is just a sampling of the code. I am actually retrieving 8 columns and want to format the date from mysql.

I tried to use the date() function within PHP in several different ways but with no success.

Thanks for the feedback...

$resultd1 = mysql_query("SELECT date, DATE_FORMAT(date, '%M %D, %Y') as fdate FROM F4HQ ORDER BY id DESC",$db);

This is a sample.

Use fdate to get your date in the right format.

OK, but how do I retrieve multiple fields within the query? It appears the example just queries date.

Got it...it was too simple!!!

$query = "SELECT *, DATE_FORMAT(rundate, '%W, %M %d') as fdate from log";