Outputs of Age are wrong? HELP

[wreed]

Ok I have a sql statement that returns this

SELECT birth, ( ( TO_DAYS( NOW( ) ) - TO_DAYS( birth ) ) / 365.25 ) AS age FROM roster WHERE name = 'M. Garon'

RETURNS

birth age

1978-01-09 25.2841

When I do PHP

$queryage = "SELECT birth, ( ( TO_DAYS( NOW( ) ) - TO_DAYS( birth ) ) / 365.25 ) AS age FROM roster WHERE name = 'M. Garon' ";
	$resultage = mysql_db_query ("restorek_islanders", $queryage);
	$playerage = mysql_result ($resultage, "age");

echo "$playerage";

Returns this 1978-01-09

ANy ideas?

[tomhath]

The fieldname should be the third argument to mysql_result. Since you didn't pass it a third argument it returned the first field selected.

Why it took "age" as the second arguement (the row) I can't explain, but I assume it converted the string to zero.