Help please

sweetcrabhoney18 · Share | #1 (**permalink**) 05-14-2007, 10:41 AM

I got this error on the script...

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sweethon/public_html/batchgame/index.php on line 89

The page comes up and everything... BUT this error worries me.. also I've been getting this error on other scripts not just this one.. so generl advice would be nice also.. any advice would be nice lol!. I tried a few things with it but nothing seemed to work so i gave up.. thanks
HERES LINE 79 TO 92

</tr>
<tr align="center" bgcolor="#666666">
<td>Batch</td>
<td>E-Gold</td>
<td>Bet</td>
<td>Win</td>
</tr>
<?
$res = mysql_query("select * from batch where gameid='$_id' order by id desc");
if (mysql_num_rows($res)>0) {
$ctr = 0;
while ($row=mysql_fetch_array($res)) {
$ctr = $ctr+1;
?>

StupidScript · #2 (**permalink**) 05-15-2007, 02:04 PM

Code:

$res = mysql_query("select * from batch where gameid='$_id' order by id desc");
if (mysql_num_rows($res)>0) {

The error you are receiving tells you that the 'resource' (mysql handler: $res) does not contain a valid array. In this case, the query didn't run properly. To troubleshoot, replace your query line with this one:

Code:

$res = mysql_query("select * from batch where gameid='$_id' order by id desc") or die ("No query: ".mysql_error());

You should now get an error explaining what happened with the query. Fix that, and your result resource should be valid.

sweetcrabhoney18 · #3 (**permalink**) 05-15-2007, 02:09 PM

Thank you.. i think i can fix it now!

alainkun · #4 (**permalink**) 05-24-2007, 11:54 PM

Please, post new MySQL error if you have one