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

[jasonc]

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());

[fenway]

That simply means that no results were returned -- you should probably wrap your second line in a "mysql_num_rows() > 0" condition.