On Sunday 13 July 2003 06:17, Andres wrote:

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

That's right, $buscar needs to be passed onto the subsequent requests through 
your 'previous' and 'next' links:


> //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;";
> }


NB you may want to urlencode() $buscar as well.

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Search the list archives before you post
System checkpoint complete.

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

Reply via email to