Error i cant figure out :-S

BIOSTALL

Hey, i have this:

$result = @mysql_query("SELECT thread_viewcount FROM Forum_Threads WHERE thread_id = '$threadid'", $connection);
		$post = mysql_result($result, 0);

Its giving me an error on the line that reads: $post = mysql_result($result, 0);

The error is 'Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/virtual/site13/fst/var/www/html/ForumReplies.php on line 19'

I just cant figure out what is wrong with it :-S if someone wudnt mind having a look. Thanks,

BIOSTALL 🙂

PVDWales

Only new myself, but I think it is the single quotes that you have around the $threadid in the SQL. The variable will not be resolved so the select will return no rows.

BIOSTALL

Well, thats how i've done it for the rest of my project and no problems :-S i cant figure it out 🙁 the $threadid is a session variable if thats got anything o do with it. lol.

laserlight

Check for error messages in mysql_query(), of course:

$result = mysql_query("SELECT thread_viewcount
	FROM Forum_Threads
	WHERE thread_id = '$threadid'", $connection)
	OR die(mysql_error());
$post = mysql_result($result, 0);

BIOSTALL

Nope, still giving the same error 🙁

laserlight

Check that there are rows retrieved, e.g. with mysql_num_rows()
If so, try an alternative method like:
$row = mysql_fetch_assoc($result);
$post = $row['thread_viewcount'];
to see if you still get the same problem.

bradgrafelman

Basically, what laserlight is doing is helping you to debug your MySQL query from past knowledge & experience.

If you'd like to see an excellent guide that explains this process, head on over to the Debugging 101 thread.