mysql第0行,MySQL-无法跳转到MySQL结果索引的第0行

随便看看喽

于 2021-01-20 21:05:04 发布

阅读量90

点赞数

文章标签： mysql第0行

这篇博客讨论了一个旧网站突然出现的PHP MySQL错误：'Unable to jump to row 0 on MySQL result index 8'。该错误通常由于查询失败或尝试访问不存在的列引起。建议检查SQL查询的有效性，确保从数据库获取了结果，再尝试使用mysql_result。作者推荐使用mysql_fetch_array代替手动获取每一列值，以避免此类问题。

摘要由CSDN通过智能技术生成

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