display category on index.php

Hi guys,

I have categories and titles tables, category belongs to titles table where it equals id field from categories table and catname belongs to categories table, in the end I would like to display catname from the categories table for each title. But there is some problems with it...

$sql = "SELECT category FROM titles WHERE `status`='A'";
$result = dbQuery($sql);
				 
		 for ($i=0; $i<mysql_num_rows($result);$i++) {
		 
		 $cat_id = mysql_result($result, $i, "category");
		 

		 $sqll = "SELECT catname FROM categories WHERE `status`='A' AND id='$cat_id'";
	     $res = dbQuery($sqll);
		
	     $catname = mysql_result($res, 0, "catname");
		 $out.= "<p>" . $catname . "</p>\n";}

PHP:

In my index.php, there is a notice:
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 11 in C:\AppServ\www\starttim\index.php on line 76

line 76: $catname = mysql_result($res, 0, "catname");;

Anybody please help!!!

 

Problem is...which line is 76? You call mysql_result two times...

 

I'd check the query by using "or die(mysql_error());"

 

I dun know what is wrong with it.

 

I can help you, please IM me(not PM) on one of the messengers in my profile.