Code Forums - View Single Post - Control table display with php & Postgresql?

tomycon · 07-17-2002, 05:49 AM

I'm running a small office intranet with postgresql database and accessing it with php. I'm able to contruct web pages that can add to the database and display a table with results from a query to the db. However, as the db has grown, a simple query can return 100+ legit responses, which makes for a very long scroll on the web page, not to mention printing!
How can I limit the display to 10+/- items per page, then have a button that will display next 10, or previous 10? Obviously there are tons of web sites out there that do this sort of thing, I can't seem to decipher it looking at "page source code".

any help would be great! thanks!

07-17-2002, 05:49 AM	#1 (permalink)
tomycon Registered User Join Date: Jul 2002 Location: Massachusetts Posts: 6	Control table display with php & Postgresql? I'm running a small office intranet with postgresql database and accessing it with php. I'm able to contruct web pages that can add to the database and display a table with results from a query to the db. However, as the db has grown, a simple query can return 100+ legit responses, which makes for a very long scroll on the web page, not to mention printing! How can I limit the display to 10+/- items per page, then have a button that will display next 10, or previous 10? Obviously there are tons of web sites out there that do this sort of thing, I can't seem to decipher it looking at "page source code". any help would be great! thanks!