php - MySQL- Unable to jump to row 0 on MySQL result index -
I have found an old site that is displaying an error which is strange because it is untouched for a while Used to be. I get the following: Unable to go to line 0 on mysql result index 8 What is the reason for this and how should I fix it? This is a PHP / MySQL site. If I remember correctly, this error is usually like a code segment: // You probably have the same code as $$ var = mysql_result ($ result, 0, 'column_name'); Where either the query fails or the column is not present, check that $ result is a valid MySQL resource to ensure that SQL is valid , Then make sure that you are actually getting results from the database before calling mysql_result . Or, even better, use mysql_fetch_array instead of getting every column value manually (if many columns are returned from your query).