Jump to content

Archived

This topic is now archived and is closed to further replies.

jasonc

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 7

Recommended Posts

The following is part of my script that does not work, the first line is what i think is causing the problem. going by the error returned.
i have had this before and looked at my other script to work it out again, but can not see anything wrong?

i wish to check one table for an email address and get the name in another table using the email address found in the first table.

can someone enlighten me?

thanks for your help.


$res = mysql_query("SELECT * FROM list WHERE email='$findstring' LIMIT 1") or die(mysql_error());

$name = mysql_result($res, 0, "name") or die(mysql_error());

Share this post


Link to post
Share on other sites
That simply means that no results were returned -- you should probably wrap your second line in a "mysql_num_rows() > 0" condition.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.