i have this simple table browse get me the filter let say 15 items of a table of 74 but after i click in the link forward the filter erase and disply me the all records... waht im doing wrong.... TNX in advance
<img src="images/misc/search.JPG" width="367" height="100" />
<br />
<?php
$strng = $_POST['search:strng'];
$separa = "%";
$all = $separa.$strng.$separa;
$mensaj="U Look for : ";
$mensaj2=$mensaj.$stng;
$regis=" u search get :";
$regis2=" Items";
$conn = mysql_connect('localhost','zerocctv_Admin','password') or trigger_error("almacen", E_USER_ERROR);
$db = mysql_select_db('zerocctv_almacen',$conn) or trigger_error("almacenz", E_USER_ERROR);
$sql = "SELECT COUNT(*) FROM modelos where descrip like '$all'";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];
$rowsperpage = 10;
$totalpages = ceil($numrows / $rowsperpage);
// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
$currentpage = (int) $_GET['currentpage'];
} else {
$currentpage = 1;
}
if ($currentpage > $totalpages) {
$currentpage = $totalpages;
}
if ($currentpage < 1) {
$currentpage = 1;
}
$offset = ($currentpage - 1) * $rowsperpage;
$sql = "SELECT modelo, paginal,precio,foto FROM modelos where descrip like '$all' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQLkk2", E_USER_ERROR);
echo $Mensaj2 ;
echo $regis. $numrows . $regis2 ;
echo "<table width=\50%\ border=\1\ bordercolor=\#0033FF\ cellspacing=\1\">" ;
while ($list = mysql_fetch_assoc($result)) {
echo "<tr>";
echo "<td>><font color='red'>" . $list['model'] . "</font></td>";
echo "<td><font color='black'>" . $list['pagl'] . "</font></td>";
echo "<td><font color='black'>" . $list['prize'] . "</font></td>";
echo "<td><font color='black'>" . $list['pict'] . "</font></td>";
echo "<tr></tr>";
echo "</tr>";
}
echo "</table>";
//****** build the pagination links ******/
$range = 3;
if ($currentpage > 1) {
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
$prevpage = $currentpage - 1;
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
}
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
if (($x > 0) && ($x <= $totalpages)) {
if ($x == $currentpage) {
echo " [<b>$x</b>] ";
} else {
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
}
}
}
if ($currentpage != $totalpages) {
$nextpage = $currentpage + 1;
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
}
?>