show php/mysql results only X number per page...

[newbieiguess]

Hi, am doing a real state site and when searching it shows all the results from the database in one single webpage, can you help me with one easy way to show only 10 results per page?

I've seen some complicated sites with previous and next arrows, i only need to show 10 results then a link to show next 10 and that's it.

Thanks for any help.

[halojoy]

I have this script
see my attached screenshot in this post:
http://phpbuilder.com/board/showthread.php?p=10826889#post10826889

Once you have put your result rows into an array
it will display all rows with contents in each field in a nice table.

Above will be a HEADER with name of each column,
if you fetch mysql_fetch_rows_associated and store this way
in your result rows catcher array.

It is not too difficult to add something to Limit display to 10 rows at the time.
I am sure someone can come up with a solution.
Maybe even you ....

Regards

[halojoy]

hi again.

10 items per page and then next 10.
This is sort of a pagination script, often with <Prev ....... Next>.

I posted this pagination script that will display like that.
Also for this script I have a Screenshot:
http://phpbuilder.com/board/showthread.php?p=10827644#post10827644

Hope you can have use for it.
🙂

[nickadeemus2002]

another option is to use a pagination class. here is one that i've used that creates digg-like pagination:

http://www.mis-algoritmos.com/2007/05/27/digg-style-pagination-class/