MySQL Query Problems

[crayzass1]

I recently sold a website (http://www.simplejokes.com) that contained no php or mysql errors. Once the site was moved to the new server, winxp XAMPP, the site no longer functions correctly. I have setup an XAMPP server on winxp to try to diagnose the problem, but have yet to figure it out.

Example of the problem: http://www.simplejokes.com
The main page of the site appears to be working correctly, joke titles and links are available and so are the categories and links. After following a category or joke link the center of the page, joke container, is empty. Am I missing something? I've looked over all the scripts and haven't been able to find a clue to why this is working incorectly.

The only error I have found is

Code: Select all

mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/simplejokes.com/httpdocs/profile.php on line 55

upon looking over profile.php and adding print error, I am left with the same error.

I have tried switching between PHP 4 and 5, but still have had no luck. Any ideas or help would be great.

[Kristian Marcroft]

Hi,

the Argument you are supplying to mysql_fetch_row() is not valid.
Please double check the varables you are passing or even getting from MySQL.

Regards,
Kristian Marcroft