Restricting Search Results 1 2 3 [u]next[/u]

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jogen143
Forum Newbie
Posts: 15
Joined: Tue Mar 25, 2003 2:51 am

Restricting Search Results 1 2 3 [u]next[/u]

Post by jogen143 »

Hi guys

I want to know how to make search result limited to 10 or 20 or whatever we want, I know how to query database and display results guys, all I want to know is some thing like this

result 1

result 2

result 3

page [u]1[/u] [u]2[/u] [u]3[/u] [u]4[/u] [u]5[/u] [u]next[/u]

and when I click next it should show results 6 to 10 with [u]previous[/u] link and [u]next[/u].

send me a piece of code or give someusefull links regarding this matter guys.

I got replies very quickly for the previous posts I made, thanks guys.

Regards
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Try Phuse:
http://use.devnetwork.net/use.php?w=f&q ... ious+limit

There's loads of info about this in the forum.

Mac
Coco
Forum Contributor
Posts: 339
Joined: Sat Sep 07, 2002 5:28 am
Location: Leeds, UK
Contact:

Post by Coco »

this really is a mysql question

you should use the SELECT option of LIMIT

check the mysql manual
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

see post Fri Feb 14, 2003 8:48 pm - search for mysql_data_seek
Post Reply