[login to view URL] is fifty tables each table is named by state example ct,ny,ca(i will need to put in the state so this can be a variable you only have to create one script)
2. each table has a column with following names id number firstname lastname homenumber street city state zipcode
what i need is to select distinct city from each table and display a static page for each state with a list of cities
then i need is to select all from the table and display a page with paging when a user clicks on the city that will have a list arranged by last name and include first name and street with 10 results per page kinda like a phonebook.
3. the name will be bold and a link to a url that will be selected from the database using id i will explain this to you better one you are selected.
Basically i have a database with people's information kind of like a phonebook. What i need is create static pages with in html that's it i do not care what language you use there 127,000,000 records so there is going to be problems beginners need not to apply. I have attached kind of the what i want the page to look like.