Re: How to show next 5 results??
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: How to show next 5 results?? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14010@lists.php.net to get a copy of this message | ||
"SELECT foo FROM bar WHERE foo='$bar' LIMIT 0,5 ORDER BY foo DESC";
That should do it!
Russ
On Mon, 5 Nov 2001 11:34:09 +0100 Andy <news.letters@gmx.de> wrote:
> Hi there,
>
> I am trying to figure out how to display only 5 results on a page.
>
> I tryed it with mysql_data_seek. This workes fine and shows 5 results.
>
> But... how do I access the next 5 results? or the previous, or give a page
> number to select?
>
> I know this is a standardprocedure, but I am a newbie..
>
> Can anybody help?
>
> Cheers Andy
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: r.j.michell@apu.ac.uk
w: www.apu.ac.uk/webteam
www.theruss.com
#-------------------------------------------------------#