pagination problem

["Andres" <adantor@epm.net.co>]

Hi all,

I have a MySQL database full with authors and titles. I made a script that
searchs a specific author and return the all his books titles, but I need it
show the results from 10 to 10. I tried with LIMIT and it return just fine
the first 10 but when I click the next 10 button it show me other 10
registers but from all the database not from the author selection I choosed.
So I think it only reads the variable I send from the form once, the second
time it seems not to read the author I want to find.  The code is this:

<?php

$buscar = $HTTP_GET_VARS['buscar'];

$conex = @mysql_connect("localhost", "root", "");
@mysql_select_db("boc", $conex);

if (!isset($_GET['page'])){
 $page = 1;
}else{
 $page = $_GET['page'];
}

$num_result = 8;
$from = (($page * $num_result) - $num_result);

$sql = "SELECT * FROM boletines WHERE (author LIKE '%$buscar%') LIMIT $from,
$num_result";
$res = mysql_query($sql, $conex);

if (!isset($tot)){
 $totquery = "SELECT  * FROM boletines WHERE (author LIKE '%$buscar%')";
 $tot = mysql_query($totquery, $conex);
}
$total_results = mysql_num_rows($tot);

if (mysql_num_rows($res)==0){
 echo "0 RESULTS";
}else{
 echo $total_results." RESULTS FOUNDED";
 echo "<TABLE>";
 echo "<TR><TD>AUTHOR</TD>";
 echo "<TD>TITLE</TD>";
 echo "<TD>PAGES</TD>";
 echo "<TD>VOL</TD></TR>";
 while ($row = mysql_fetch_array($res)){
  echo "<TR><TD>".$row["Author"]."</TD>";
  echo "<TD>".$row['Title']."</TD>";
  echo "<TD>".$row['pages']."</TD>";
  echo "<TD>".$row['Vol']."</TR>";
 }
 echo "</TABLE>";
}

//previous link
$total_pages = ceil($total_results / $max_results);
if ($page > 1){
 $prev = ($page - 1);
 echo "<a
href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a>&nbsp;";
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i&nbsp;";
        } else {
            echo "<a
href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a>&nbsp;";
    }
}

// next link
if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
}
?>

I would appreciate any help.

I'm a newby, so be the most especific you can...Many thanks guys.

Andres



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php