Pagination

[slimjim]

I have read so many post on pagination and I cant figure it it out on how to get it to work with the below code. If anyone can help me out would be great. Spent countless hours trying to understand how everyone is doing it from the posting on here and still cant figure how to use it with the below code.

$query = "select id,title,homeurl,dlurl,demourl,descr,price,version,hitsout,added from $tablescripts where subcat='$id' and status='1' order by hitsin desc";
$result = mysql_query($query) or die("Failed: $query");
$numrows = mysql_num_rows($result);
$catid = $id;
for($x=0;$x<$numrows;$x++){
	$resrow = mysql_fetch_row($result);
	$id = $resrow[0];
	$title = $resrow[1];
	$homeurl = $resrow[2];
	$dlurl = $resrow[3];
	$demourl = $resrow[4];
	$descr = $resrow[5];
	$price = $resrow[6];
	$version = $resrow[7];
	$hitsout = $resrow[8];
	$added = $resrow[9];
	$aradded = explode(" ", $added);
	$added = $aradded[0];
	$title .= " ".$version;
	if (($ckAdminPass) && ($ckAdminPass==$adminpass)) $adminurl = " &nbsp;&nbsp;<font color='$table_head_textcolor'>[</font><a href='cat.php?admindelete=$id'><font color='$table_head_textcolor'>X</a></a>]";
	$links = "";
	if ($homeurl) $links .= "<font size='-1' face='$fontname'><font color='$table_head_textcolor'> <a href='out.php?id=$id&home=1' target='$id'><img border=\"0\" src=\"".$script_index_url."home1.gif\" width=\"80\" height=\"31\"></a> </font> ";
	if ($dlurl) $links .= "<font size='-1' face='$fontname'><font color='$table_head_textcolor'> <a href='out.php?id=$id&dl=1'><img border=\"0\" src=\"".$script_index_url."download.gif\" width=\"80\" height=\"31\"></a> </font> ";
	if ($demourl) $links .= "<font size='-1' face='$fontname'><font color='$table_head_textcolor'> <a href='out.php?id=$id&demo=1' target='$id'><img border=\"0\" src=\"".$script_index_url."demo1.gif\" width=\"80\" height=\"31\"></a></font> ";
	$descr .= "<br><i>Price: $price - Added: $added - Hits: $hitsout</i>";
	print "<table width='$table_width' border='$table_border' cellspacing='$cellspacing' cellpadding='$cellpadding' align='center' bordercolor='$table_border_color'>
	  <tr> 
	    <td bgcolor='$table_head_color'><img border=\"0\" src=\"".$script_index_url."folder3.gif\" width=\"38\" height=\"28\"><font size='-1' face='$fontname'>&nbsp;&nbsp;&nbsp;<b><a href='view.php?id=$id'><font color='$table_head_textcolor'>$title</font></a>$adminurl</b></font></td>
	    <td bgcolor='$table_head_color' align='right'><font size='-1' face='$fontname'>&nbsp;$links</font></td>
	  </tr>
	  <tr> 
	    <td bgcolor='$table_bgcolor' colspan='2'> 
	      <blockquote> 
	        <p><font size='-1' face='$fontname' color='$table_textcolor'>$descr</font></p>
	      </blockquote>
	    </td>
	  </tr>
	</table><br>";
}

[slimjim]

Anyone at all out here that can help me out ? Please 😃

[planetsim]

What type of pagination

Prev 1 2 3 4 Next or

Prev Next?

Anyway the basics of pagination is have one Query that gathers the information limited and a second query without the limited parameter.

From there your second query is what will be worked with.

So count the number of rows there are, than divide the total rows by the limit

so the formula

page = total / limit

From there is IF statements

So firstly the previous link

if (($page-$limit) != 0) {
  //do previous
}
#Now the Next Link
if(($page+$limit)<$numrows) {
  //do next link
}

I havent tested it but its the basics of what is required.

I hope that helps just a little