query is wrong?

This is related to php too:

$sqlQuery = "Select *, MONTHNAME('dateSigned') as month from guestbook ORDER BY name";
$result = mysql_query($sqlQuery, $db) or die("Unable to query database.");
while($myrow = mysql_fetch_array($result)) {
$dateSigned = $myrow["month"];

printf("Date: %sn", $dateSigned);
}
?>

the field dateSigned is a date field. (2000etcetcetc) so all i want to do is extract the month from this. Shouldn't It make a temporary field so all i have to do is use "month"?????????? $myrow["month"] is always empty :/

Thanks in advance!

Cisk

You need to remove the single quotes from around dateSigned in the MONTHNAME function. When referring to a column name NEVER use quotes. Using quotes tells MySQL to perform the function on what's in the quotes, NOT on the contents of the field.