mysql_result() error happening all of a sudden

Question

I recently rebuilt my website and now I'm getting this error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/xx/public_html/asdf.com/comsel.php on line 28

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/xx/public_html/asdf.com/comsel.php on line 29

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/xx/public_html/asdf.com/comsel.php on line 30

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/xx/public_html/asdf.com/comsel.php on line 31

Those lines are as follows:

mysql_connect($dbhost,$dbuser,$dbpass)
or die("Error: Failed to connect to database");

mysql_select_db($dbname)
or die("Error: Failed to select databse");

$query = "SELECT * FROM foxlose ORDER BY RAND ( ) LIMIT 1";

$result = mysql_query($query);



$title = mysql_result($result,$i,"title");
$link = mysql_result($result,$i,"link");
$nomen = mysql_result($result,$i,"name");
$text = mysql_result($result,$i,"text");


mysql_close();

The last four lines before mysql_close(); are lines 28-31.

Only here's the thing: those lines were the same in the old version of my site, and they worked. I can't figure out what's changed. The code also works fine when I use my computer as a server and host it locally.

Any idea what this error is trying to tell me?

Edit: Added all mysql in the document.

Answer 1

It seems to me odd that you close the connection to a database by:

mysql_close();

and then you use

$variable = mysql_result(...);

Generally, if you want to know the reason of the error use the function mysql_error.

Answer 2

Try removing the space after RAND:

$query = "SELECT * FROM foxlose ORDER BY RAND() LIMIT 1;

Answer 3

There are several things you could do here.

1. Check the mysql_query connection is actually set. Alternately youcan ensure the connection is being passed by passing it to the mysql query

i.e.

mysql_query($query, $connction);

1. Additionally, Thomas Clayson pointed out, ensure you are getting results. If there are no results mysql_result will throw an error

2. Ensure mysql_select_db (assuming you are using this), is connecting to the database properly.

3. Depending on versions and such you may need a semicolon to close your mysql statement

i.e.

$query = "SELECT * FROM foxlose ORDER BY RAND () LIMIT 1;";

Much of this has been taken from other people with similar issues. full credit (and more ideas) here: http://www.daniweb.com/forums/thread26425.html