limit # of returned records

ahasanat

The script works fine, I want to be able to limit the number of records the script return on each page to maybe 10 or 12. Also to give the user the option to go back and forward by clicking on maybe Next or Previous. If anybody know the answer, please let me know.

<?php

if (!($link = @ mysql_connect($dbhost, $dbuser, $dbpass)))
die("Could not connect to Server");

if (!mysql_select_db($dbname, $link))
die("Could not connect to database");

  $sql="SELECT * FROM dtable WHERE cat='$cat' ";
  $result = mysql_query($sql);

  while ($myrow = mysql_fetch_array($result)) 
  {
	   echo "<table width=100% border=0 cellpadding=0 cellspacing=0>";

echo "<tr> <td height=60 width=100 valign=center><a href= http://$myrow[siteurl] target=_blank title=$myrow[sitename]><img src=/logo/$myrow[imagename] width=88 height=31 border=0 align=baseline hspace=10 vspace=0 alt=$myrow[sitename]></td>";

echo "<td valign=top width=320 align=left><a href=http://$myrow[siteurl] class=navcolor target=_blank title=$myrow[sitename] style=text-decoration:none;color:#003399> $myrow[sitename]<br><font color=black face=arial,helvetica,sans-serif size=1 style=text-decoration:none;align:justify;>$myrow[linktext]</font></a> </tr>";

echo "<tr> <td height=13 width=100% colspan=2><img src=linehg.jpg width=100% height=1></td> </tr></table>";
}
?>

bretticus

In MySQL, you can use LIMIT to return a specific amount of records from anywhere in the recordset. Then just use a few variables and some trivial math to limit records per page.

//initialize page number

if(!isset($pg)){$pg=1;}

//Specify how many rows you want to return:

$rows_per_page = 10;

//set current page number (comes from link i.e page.php?pg=2)

$curr_page = $pg;

//get upper boundary of records you want to return, so you know where to start.

$ub = $curr_page*$rows_per_page;

//subtract $rows_per_page to get $start.

$start = $ub - $rows_per_page;

//Now make your query:

$query = "SELECT * FROM table LIMIT $start,$rows_per_page";

Anon

The best way you can limit the record in Sql is through query. In query return as you much record as you like and after put it in php pass arguments in query so it will return you the required record.

Rizwan

ahasanat wrote:

<?php

if (!($link = @ mysql_connect($dbhost, $dbuser, $dbpass)))
die("Could not connect to Server");

if (!mysql_select_db($dbname, $link))
die("Could not connect to database");

  $sql="SELECT * FROM dtable WHERE cat='$cat' ";
  $result = mysql_query($sql);

  while ($myrow = mysql_fetch_array($result)) 
  {
	   echo "<table width=100% border=0 cellpadding=0 cellspacing=0>";

echo "<td valign=top width=320 align=left><a ....

ahasanat

Thank you very much for your effort.

I have two ?

1- how do I deal with Next page and Previous Page, becuse I want the user to have the ability to go back and forward between pages once he did the selection.

2- what is this line mean:

//set current page number (comes from link i.e page.php?pg=2)

$curr_page = $pg;

do I have to set the $pg, or I need to use it in my Next and Previous links.