[RESOLVED] error message - mysql_fetch_array

duckduckgoose

If I enter this query at the sql prompt, I'll get results, but the code at the end of this yields the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...on line 104

$query = "SELECT * FROM activity, customers WHERE activity.UserID=customers.UID AND (month(thisDateField) = month(now()) and dayofmonth(thisDateField) = (dayofmonth(now())-1) and year(thisDateField)=year(now())) ORDER BY
activity.thisDateField";

    $result = mysql_query ($query); 

    while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {  // This being Line 104

Can someone shed some light?

laserlight

Check:

Your database server connection.
That the appropriate database was selected.
That the query is correct.

duckduckgoose

Yes, all of those things are correct.

duckduckgoose

Looks like I needed an @ sign in front of mysql_query & mysql_fetch_array

laserlight

Yes, all of those things are correct.

That cannot be. Double check, use mysql_error() if needed, e.g.

$result = mysql_query($query) OR die(mysql_error());

Looks like I needed an @ sign in front of mysql_query & mysql_fetch_array

No, you dont. All you are doing is suppressing the error, sticking your head in the sand.