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:
[snip]
> //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> ";
> }
href=\"".$_SERVER['PHP_SELF']."?page=$prev&buscar=$buscar\"><<Previous</a> ";
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
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
System checkpoint complete.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
