pagination..

[housey]

Hi,

I've been trying to add pagination links to one of my pages... I'm trying to modify some code that was posted here. The records are output to the page but I don't get any links. Also I think there is a problem with the 'while' loop i'm using to pull the records out, I think all records will be retrieved on every page. So on page 2 page ones records will read too.. which surely is bad..

<?php require('includes/header.php'); 

 $limit = 5; // rows per page
if (!isset($row)) $row= 0; 

$server="localhost";
$username="root";
$password="";
$database="db";

mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table LIMIT $row,$limit";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {




// database fields are output here in a table



$i++;
}

?>
</p>

<center>

<?php

// prev / next links

if (($row - $limit) > 0){
  $var = $row-$limit;
  $back = "<a href=\"page.php?row=$var$extraurl\"><b><< back</b></a>";
};

if ($row != 0 && ($row - $limit) <= 0 && $row != ""){
  $back = "<a href=\"page.php?row=0$extraurl\"><b><< back</b></a>";
};

if (($row + $limit) < $num){
  $var = $row+$limit;
  $next = "<a href=\"page.php?row=$var$extraurl\"><b>next >></b></a>";
};

print $back.$next; 

?>
</center>

[Nomaad]

Here is the way Dreamweaver runs recordset paging:

<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_test = 5;
$pageNum_test = 0;
if (isset($GET['pageNum_test'])) {
$pageNum_test = $GET['pageNum_test'];
}
$startRow_test = $pageNum_test * $maxRows_test;

mysql_select_db($database_fieldcontent, $fieldcontent);
$query_test = "SELECT * FROM contractor_db";
$query_limit_test = sprintf("%s LIMIT %d, %d", $query_test, $startRow_test, $maxRows_test);
$test = mysql_query($query_limit_test, $fieldcontent) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);

if (isset($GET['totalRows_test'])) {
$totalRows_test = $GET['totalRows_test'];
} else {
$all_test = mysql_query($query_test);
$totalRows_test = mysql_num_rows($all_test);
}
$totalPages_test = ceil($totalRows_test/$maxRows_test)-1;

$queryString_test = "";
if (!empty($SERVER['QUERY_STRING'])) {
$params = explode("&", $SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_test") == false &&
stristr($param, "totalRows_test") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_test = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_test = sprintf("&totalRows_test=%d%s", $totalRows_test, $queryString_test);
?>
<a href="<?php printf("%s?pageNum_test=%d%s", $currentPage, max(0, $pageNum_test - 1), $queryString_test); ?>">Previous</a>
<a href="<?php printf("%s?pageNum_test=%d%s", $currentPage, min($totalPages_test, $pageNum_test + 1), $queryString_test); ?>">Next</a>

<?php do { ?>
<tr>
<td><?php echo $row_test['list_id']; ?></td>
<td><?php echo $row_test['date']; ?></td>
<td><?php echo $row_test['name']; ?></td>
<td><?php echo $row_test['company']; ?></td>
<td><?php echo $row_test['address']; ?></td>
<td><?php echo $row_test['city']; ?></td>
<td><?php echo $row_test['state']; ?></td>
<td><?php echo $row_test['zip']; ?></td>
<td><?php echo $row_test['phone']; ?></td>
<td><?php echo $row_test['fax']; ?></td>
<td><?php echo $row_test['email']; ?></td>
<td><?php echo $row_test['products_in_use']; ?></td>
<td><?php echo $row_test['primary_services']; ?></td>
<td><?php echo $row_test['updates']; ?></td>
</tr>
<?php } while ($row_test = mysql_fetch_assoc($test)); ?>

[ionescu_raul]

U should take a look here
That solution also applies for MySQL.