In a MySQL query you can use the LIMIT keyword, like in phpmyadmin.
Use limit 0,10 to get the first ten results in a query.
Then do the query again but use 10,10 for the limit.
The first number is the "offset", and the second one is the maximum results
to return.
That's the way most people do "pages".
--
Plutarck
Should be working on something...
...but forgot what it was.
""Jason Caldwell"" <[EMAIL PROTECTED]> wrote in message
9b8rgd$oot$[EMAIL PROTECTED]">news:9b8rgd$oot$[EMAIL PROTECTED]...
> Does anyone know (or have) of a good example of how to create search
results
> like a Yahoo or MSN search?
>
> for example:
>
> Say I do a search for "cars" and there are 10,000 records in my table that
> match "car"... I would like to show the results in blocks of (say) 25 at a
> time, therefore I will need a "Next Results", "Previous Results", "Total
> Records found that match my query", and perhaps, between the "Previous
> Results" and "Next Results" a set of numbers like so;
>
> <Previous [1] [2] [3] [...] Next>
>
> The numbers being "jump to" links, etc.
>
> Thanks.
> Jason
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
