Overflowing Result Pages

Scipio

Heh don't know really what to call what it is I am trying to build but I think I can explain it ok.

I have a database full of names (ID, name, etc.)

Now what I need to do is split the page that shows the results of a specific city into:

A) Alphabet pages (so that click a and you see all a's of that city etc.)

😎 Numbered pages inside of the alphabetized pages (so if the A section of a city has a lot of results it will then split it further into pages 1, 2, 3, 4, etc.)

I will make a follow up post of what I have thought up.

Scipio

Ok, my way of solving this page (Not writing code here but theory).

1. Page gets the cityname to get results of from intro page.

2. Page queries the database and gets only the name ID's in that city starting with A (unless specified by user using the A, B, C, D links).

3. Page stuffs these ID's into an array.

4. Page counts how many rows in the array, if there are more than say.. 20 rows then mark this result page as overloaded (IE: $overloaded=true; ).

Page see's that $overloaded = true and then executes the following

5. Make another query to DB this time getting Names of the corresponding ID's in the array of rows 0-19 ONLY.

6. Display these results on the page.

7. Find out how many groups of 20 results there are (numRows / 20).

8. Based on the ammount of groups of 20 there are create links something like ./selfpage.php?overflow=1.

9. When you click on these links the page with the above functions in it would then notice the $overflow=1 and say hey, instead of showing 0-19 rows of the array in step 5, show 20-40.

I hope you know what I am talking about lol. Tell me if my logic is.....logical heh.

Thanks, Scipio.