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.
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).