Page 1 of 1

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

Posted: Fri Apr 11, 2003 3:32 am
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

Posted: Fri Apr 11, 2003 3:54 am
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

Posted: Fri Apr 11, 2003 6:47 am
by Coco
this really is a mysql question

you should use the SELECT option of LIMIT

check the mysql manual

Posted: Fri Apr 11, 2003 6:26 pm
by McGruff
see post Fri Feb 14, 2003 8:48 pm - search for mysql_data_seek