Something WRONG with my code??????

[Anon]

I've got a problem.... check out my codes below:

function main($cat_id,$subcat_id)
{

$num="SELECT * from recreation_main AS a WHERE a.cat_id=$cat_id AND a.subcat_id=$subcat_id";
$num = mysql_query($num);

while( $row = mysql_fetch_array($num))
{
$x=$row[id_no];
$y=$cat_id;
$z=$subcat_id;

		$query="SELECT c.country FROM recreation_main AS a JOIN country AS c WHERE a.id_no=$x AND a.cat_id=$y AND a.subcat_id=$z AND a.country_id=c.country_id"; 
		$results=mysql_query($query);
		$row = mysql_fetch_array($results);
		?><u><?echo $row["country"];?></u><br><?

		$query="SELECT a.coy_name, a.description FROM recreation_main AS a WHERE a.id_no=$x AND a.cat_id=$y AND a.subcat_id=$z"; 
		$results=mysql_query($query);
		$row = mysql_fetch_array($results);
		$des = $row["description"];
		if ($row["description"]!=NULL && strstr($des,"("))
		{
		$brac = strstr($des,"(");
		$des = rtrim($des,$brac);
		echo $des;{?><br><?}echo $brac;{?><br><?}
		}
		else if ($row["description"]!=NULL)
		{
		echo $des;{?><br><?}
		}
		?><b><?echo $row["coy_name"];?></b><?

		$query="SELECT b.address FROM recreation_main AS a JOIN address AS b WHERE a.id_no=$x AND a.cat_id=$y AND a.subcat_id=$z AND a.id_no=b.id_no"; 
		$results=mysql_query($query);
		$num_results = mysql_num_rows($results);
		for ($i=0; $i<$num_results; $i++)
		{
			$row = mysql_fetch_array($results);
			if ($row["address"]!=NULL)
			{?><br><?}
			$str = $row["address"];
			$len = strlen($str);			
			if ($len > 35)
			{$st = substr($str,0,-16);
			 echo $st;
			 $str = substr_replace($str, " ",0,-16);
			 {?><br><?}
			 echo $str;
			}
			else echo $str;
		}?><br><?
		$query1="SELECT d.type, c.telephone FROM recreation_main AS a JOIN telephone AS c JOIN typephone AS d WHERE a.id_no=$x AND a.cat_id=$y AND a.subcat_id=$z AND a.id_no=c.id_no AND c.type_id=d.type_id";
		$result=mysql_query($query1);
		$num_result = mysql_num_rows($result);			
		for ($i=0; $i<$num_result; $i++)
		{
			$row = mysql_fetch_array($result);
			echo $row["type"];
			echo " :";
			echo $row["telephone"];
			?><br><?
		}
		$query2="SELECT f.email FROM recreation_main AS a JOIN email as f WHERE a.id_no=$x AND					a.cat_id=$y AND a.subcat_id=$z AND a.id_no=f.id_no";
		$result=mysql_query($query2);
		$num_result = mysql_num_rows($result);
		for ($i=0; $i<$num_result; $i++)
		{
			$row = mysql_fetch_array($result);
			$value=$row["email"];
			echo "<a href=\"mailto:$value\">$value</a>";?><br><?
		}
		$query2="SELECT e.url FROM recreation_main AS a JOIN url as e WHERE a.id_no=$x AND						a.cat_id=$y AND a.subcat_id=$z AND a.id_no=e.id_no";
		$result=mysql_query($query2);
		$num_result = mysql_num_rows($result);
		for ($i=0; $i<$num_result; $i++)
		{
			$row = mysql_fetch_array($result);
			$value=$row["url"];
			echo "<a href=\"$value\">$value</a>";?><br><?
		}
?><br>
<?}

}
?>

Izzit possible for me to retrieve using SQL statements without using id_no?? Or is there another way that without removing anything above and yet could use LIMIT function and do the "Next Page" function?

Thanks a lot for your help.. I'm really kinda stuck here for a LONG time...