What\'s wrong with this code?

[Anon]

function formatDate() {
$Query = \"SELECT part_date FROM parts;\";
$Results = mysql_db_query(\"system\", $Query) or DIE(\"Gather Date Info Failed\");
while ($row = mysql_fetch_row($Results)) {
$date = \"SELECT FORMAT_DATE(\'$row[0]\', \'%W %d %M %Y\');\";
}
echo \"$date<br>\";
}

This code outputs \"SELECT FORMAT_DATE(\'$20010130\', \'%W %d %M %Y\');\" I want it to format the date for me. It gets the date value from the $row[0] variable. I am too new to understand exactly what I need to do to fix this.

Thanks!

[kparker]

format_date() (or, actually, date_format() ) is a mysql function, not php, so you need to use it in the query itself:

$query = "SELECT date_format(part_date,'%W %d %M %Y') FROM parts";

Then, when you fetch the row(s), $row[0] will contain an already-formatted string representation of the date.