[RESOLVED] Problem (warning) after switching from PHP 5.2.17 to 5.3.8

[AYC462118]

Hey!

I have a code that have worked perfectly until just recently when I upgraded my Wamp from 2.1 to 2.2 which effectivly changed PHP version from 5.2.17 to 5.3.8. The problem/warning I get is the following:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in c:\wamp\www\index.php on line 25

The code the warning seems to concern is the following:

$A = "SELECT * FROM p" or exit (mysql_error()); $B = mysql_query($A);

while ($C = mysql_fetch_array($B)) {

 echo $C["title"];

}

And the strange thing is that I havent changed anything in the query or in the code itself. All that has been changed is the version of PHP.

What am I missing? 😕

All answers is highly appreciated!

[Weedpacket]

AYC46118 wrote:

$A = "SELECT FROM p" or exit (mysql_error());

This line won't help you: the exit() will only be reached if the string "SELECT FROM p" failed to be assigned to $A - and even then, it won't have anything to say because it wouldn't be a MySQL error.

Try putting "or exit..." on the query and you'd have a better chance of getting a usable error message.

As for the problem, see the question "why has my site suddenly stopped working?" in the Upgrade PHP Forum's FAQ. That has some suggestions about what to look for.

[AYC462118]

I "solved" the problem now. I completely forgot that with the new installation of Wamp, I lost my "localhost"-database and forgot to import it. 😛