MySQL- Unable to jump to row 0 on MySQL result index

I have got an old site that has recently been displaying an error which is weird as its been untouched for some time. I get the following:

Unable to jump to row 0 on MySQL result index 8

What is the cause of this and how should I fix it?

It is a PHP/MySQL site.

Answers


If I remember correctly, this error typically stems from a code segment like the following:

// You probably have some code similar to this
$var = mysql_result( $result, 0, 'column_name');

Where either the query fails or the column doesn't exist. Check that $result is a valid MySQL resource to make sure that the SQL is valid, then make sure you're actually getting results from the database before trying to call mysql_result.

Or, better yet, using mysql_fetch_array instead of manually fetching every column value (if you have multiple columns returned from the query).


Need Your Help

JQuery iterate through current SELECT values

javascript jquery select

how do you iterate through just the current values of all selects, not the options?

jQuery: creating a custom event

jquery

I'm supposed to create a custom event triggered on page load that adds a class 'green' to the div with the id #myElementId. This is my attempt at the code but I'm getting an error message saying t...