hmm.. can't figure out this error!?

[phence]

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 6 in /home/www/chrisdavis/Projects/index.php on line 208

I get this error from this line of code...

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM projects LIMIT $from, $max_results"),0);

I don't know why i am getting this error. I am using this line of code in a script that will allow me to have mutiple results on multiple pages. "PAGINATION"... I have multipul sites using this script, but only this site here is having this kind of error.

Can point me where to look for this problem? i'll post the entire script if necessary.

Thanks!

[tsinka]

Hi,

change the code to:

$sql = "SELECT COUNT(*) as Num FROM projects LIMIT $from, $max_results";

$res = mysql_query($sql) or die("Query error: ".mysql_error());

list($num) = mysql_fetch_row($res);

echo $num;

Something might be wrong with the query.

Thomas

[TruckStuff]

One usually sees that error when an empty data set is returned by MySQL. It can't access row 0 because there is no row 0.