How to fix: "Warning: mysql_fetch_ass oc(): supplied argument is not a valid . . "?

[wilsonh]

Hi

I am aware that this is a common problem as I have scoured the internet endlessly looking for a solution.

The script was installed and set up for me because I am a complete beginner so unfortunately I have made little sense of some of the solutions that have been posted.

I have looked into it and now have some understanding of what the code should be doing or what it is trying to do.


The error is

"Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL result resource in /path/to/file/index.php on line 213"

Line 213 is....

while($row = mysql_fetch_assoc($rs)) {
 

This is strange because this script originally worked absolutely fine until I tried uploading a new design for the index page (with the original php code re-inserted).
I have even uploaded the original files (but left the db intact) and the error still occurs.

I spoke to a friend of mine and he mentioned something about the variable being returned as false and I need to perform some type of operation on the database maybe.

Do you have any suggestions on what I need to do?

This is the code that connects to the db...

$conn = mysql_connect($hostname,$username,$password) or die("Having problem connecting to database");
    mysql_select_db($dbname,$conn);

I can also provide the full code by request.

Thanks in advance

Will

[wilsonh]

Ok thanks for that!
I'll have a scour around and see if I can find anything!