mysql_fetch_array doesn't work on host

[jpmoriarty]

I have a script that runs fine on my machine no problem. But when I upload it, I get the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../data-summary.php on line 116

my code in question is the following:

	echo "\n\n<p>$query</p>\n\n";

$result = $db->select($query); 

while ($row=mysql_fetch_array($result))
{
	echo "\n\t\t<tr>
			<td><a href=\"data-display.php?schoolid=".$row['id']."\">".$row["SchoolName"]."</a></td>
			<td>".$row["NoPupils"]."</td>
			<td>".$row["AgeLower"]." &ndash; ".$row["AgeUpper"]."</td>
			<td>".$row["Gender"]."</td>
			<td>".$row["FullBoarders"]."</td>
		<tr>\n";
} 

and line 116 is the while($row=mysql_fetch_array... line. If I copy the echoed out query and run it from the SQL input on PHP My Admin, the query runs fine and I get 41 results. But when I run the script, nothing.

And as I say, with the same script run locally (on a db that i've exported from my local and then just imported to my online one) it runs without a hitch. I'm using a db class that again runs fine locally.

[leatherback]

Lets start with the obvious.. Did you change your database connection files properly for the online server?

[jpmoriarty]

yep - am not getting any problems when I connect to the DB, nor on line ($result = $db->select($query); ) - which I presume is where the first error would occur if I couldn't get connected to the DB properly (not to mention earlier on when i set up my db connection)

[bradgrafelman]

What class is $db ? Does this class have some form of error handling? It's quite possible your query is failing and that the error can be retrieved from one of this class' functions.

In fact, since your while() loop is using the procedural style of MySQL commands, why even have a database class at all?