SQL Error - Anyone know what I have done wrong?
Posted: Fri Feb 06, 2004 4:02 am
Hi guys,
I have been trying to figure this out but can't. I keep getting this error in my mysql_result line:
Warning: Unable to jump to row 0 on MySQL result index 3 in c:\program files\easyphp\www\cmr\list.php on line 42
Here is the code:
There are more lines following like the $date=mysql_result($r,0,"date");
Does anyone have an idea of what I am doing wrong here?
Thanks and Kind Regards - Trvo
I have been trying to figure this out but can't. I keep getting this error in my mysql_result line:
Warning: Unable to jump to row 0 on MySQL result index 3 in c:\program files\easyphp\www\cmr\list.php on line 42
Here is the code:
Code: Select all
while($x < $count) {
$x++;
$r = @mysql_query("SELECT * FROM logbook WHERE 'id'=$x");
if (!$r) die ('Query for count failed: '.mysql_error());
$date=mysql_result($r,0,"date");Does anyone have an idea of what I am doing wrong here?
Thanks and Kind Regards - Trvo