mysql_num_rows(): supplied argument is not a valid MySQL

[matheussousuke]

I'm having the following trouble:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mghosped/public_html/anuncieaki/lib/func_common.php on line 149


This is the line 149

for ($i=1; $i<mysql_num_rows($result); $i++  )

The same script works fine in another server, but not in that one.

[Dormilich]

check if mysql_query() return false.

[matheussousuke]

@Dormilich
Where do I check that?

Ps: I've no access to php.ini.

[Dormilich]

@matheussousuke

$result = mysql_query($sql) or die("Oops, I did it again: " . mysql_error());

[matheussousuke]

@Dormilich


I guess I got it, I've do following on the lines 234 and 136:

 $result = mysql_query($query, $myDB);

Is this that I need to change?

[Dormilich]

yepp
___________________

[matheussousuke]

@matheussousuke

So it will be like this?

$result = mysql_query($query, $myDB);or die("Oops, I did it again: " . mysql_error());

[Dormilich]

without the first semicolon.

[matheussousuke]

@Dormilich

Now I got the following error:

Oops, I did it again: Table 'mghosped_akidb.std_categories' doesn't exist

[Dormilich]

if this table does not exist, you cannot query it…

[matheussousuke]

@matheussousuke
Oops, I did a terrible mistake, wait a minute.

[matheussousuke]

Ok, I did it. Thanks.