mysql fetch_array error

Question

I'm trying to make a simple mysql_fetch_array but for some reasons I get the error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\get.php on line 5"

$sql = mysql_query("SELECT * FROM mxc WHERE exp_year > 2009 AND status=0 GROUP BY c_number");

 while($row = mysql_fetch_array($sql))
{
....

Any idea what's wrong with my code ? thanks in advance for any help !

From my experience, such errors occur when an invalid query is given. Queries can be invalid for silly reasons such as typo in name of column. You could do a double check on that. — Shamim Hafiz - MSFT
– Shamim Hafiz - MSFT, Commented Sep 12, 2010 at 16:42

Amber · Accepted Answer · 2010-09-12 16:41:20Z

4

Chances are you have a mysql error. Change your query line to this:

$sql = mysql_query("SELECT * FROM mxc WHERE exp_year > 2009 AND status=0 GROUP BY c_number") or trigger_error(mysql_error());

And see what output you get.

answered Sep 12, 2010 at 16:41

Amber

531k89 gold badges643 silver badges558 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1