Hey, At home I had a mysql serve

[sjaakdelul]

Hey,

At home I had a mysql server (3.23), PHP (4.2.2)and an apache server ... until the big crash

Now, I've saved my files at a server of a friend.
But when I run the scripts, I get the follow error:


"Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/

http://www/vhosts/molegraaf.com/httpdocs/index_cijferlijst.php

on line 12"


Line 12: while($object = mysql_fetch_object($query)){
Line 13: $gebruikersnaam = $object->gebruikersnaam;
Line 14: }

At another file, I got the almost the same error (now Mysql_fetch_array()):


"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/

http://www/vhosts/molegraaf.com/httpdocs/view_cijferlijst_vervolg.php

on line 114"


Line 114: while ($results_array = mysql_fetch_array($results)) {


At my server there weren't any mistakes ...
Does anyone know the meaning of the error?

 

[sleipnir214]

That error is happening because your query is failing.

When a query fails, mysql_query() returns FALSE, which is not a valid result resource.

Test the variable in which you're storing the resource handle against FALSE. If it is FALSE, output the return of mysql_error() to see what is going wrong. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sjaakdelul]

Can another version of apache or php be the reason for the problem?

 

[805pr]

Have you checked "register_globals =" setting in php.ini & tried it with them on vs off. ? It sounds like your variable $query is not getting passed.



Mike

 

[sleipnir214]

I doubt it's a register_globals problem. That doesn't cause this kind of thing.

It's most likely database permissions. But without seeing the errors, we'll never know. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!