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:


$buscar = $HTTP_GET_VARS['buscar'];

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

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

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

$sql = "SELECT * FROM boletines WHERE (author LIKE '%$buscar%') LIMIT $from,
$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";
 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

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i&nbsp;";
        } else {
            echo "<a

// 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.


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

Reply via email to