Re: mysql_result(): supplied argument is not a valid.....

here is my code:
line 39 $total_1 = mysql_query("SELECT COUNT(*) FROM COASTERS");
line 40 $total_coasters = mysql_result($total_1,0,0);
line 41 $total_2 = mysql_query("SELECT COUNT(*) FROM COUNTRIES");
line 42 $total_countries = mysql_result($total_2,0,0);
line 43 $GET_DATE = mysql_query("SELECT DATE_FORMAT(DATE,'%d.%m.%Y')
FROM COASTERS ORDER BY DATE DESC LIMIT 1");
line 44 $update = mysql_result($GET_DATE,0,0);

I get errors on line 40, 42 and 44 and I'm only counting the records
and getting the latest date,,, And what's strange is that it works
local!!!!
Received on Mon Oct 17 21:05:59 2005