TECH PHP Help

[k2737]

I want to display the contents of a database and have no trouble doing that but I need a nice way to navigate through all of the records in the database. There are about 1,000 records now so I want to have a navigation menu similar to OT's page menu. So something like:

1-25 26-50 etc

And have each being a link to displaying those records. Do you guys know of a online tutorial or even what something like that would be called to aid in my googling?

 

[White Stormy]

this would be so easy in Drupal

 

[White Stormy]

if the rows have index/id fields, you could pass 2 variables in a query string.. x variable is what row to start at.. y variable is how many to show per page.. then the php just searches for the starting x index and grabs y rows

http://www.w3schools.com/php/php_mysql_select.asp

build the links at the bottom of the page using the same variables

 

[k2737]

Unfortunately there isn't any type of ID or index for each record so they have to be counted. I found this link and I think it will help me do what I want...

http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html?page=2

The problem I am having now is when I do the initial count something is timing out and it isn't finishing the query. The database is on an older machine and there are a ton of files stored in the database so I think I am going to have to figure out how to clean that up and fix the timeout issue first.