Help needed in using "next page" feature

[Anon]

I'm trying to use "next page" and "previous page" feature.. but have a problem as I couldn't use the LIMIT function within my codes due to the way I program my SQL... can someone help me??

Here's my code:
function main($cat_id,$subcat_id)
{
$num="SELECT COUNT(a.id_no) from recreation_main AS a WHERE a.cat_id=$cat_id AND a.subcat_id=$subcat_id";
$num = mysql_query($num);
list($count) = mysql_fetch_row($num);

$number="SELECT MIN(a.id_no) from recreation_main AS a WHERE a.cat_id=$cat_id AND a.subcat_id=$subcat_id";
$number = mysql_query($number);
list($small) = mysql_fetch_row($number);

for ($x=$small,$y=$cat_id,$z=$subcat_id; $x<($count+$small); $x++)
{
$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>
<?}

}