I want to create 1 master database in MySQL and create a lot of ASP pages for hyperlinking.

For eg, I create an index page that has a list of lot of cities. I want a database that will have the hyperlink locations of all the individual html pages of these cities. I want to link to these city pages from the index file thru the master database. Something like this... www.mydomain.com/index.asp?viewcity=194

When the user clicks on this city link, that individual page that I have created should be displayed with the ?viewcity=194 in the address bar. I dont want the user to know the direct location of the html or target page...

This will also be helpful for me as I will have a lot of updations. I can just update the backend MySQL and the link in the index asp...

Kindly let me know how I should do this... And also let me know about 1 more query... I have seen websites that link as www.mydomain.com/index.asp?viewcity=194&detailed=yes

If I want a short view of the data, I can create an asp target page that will just retrieve the short itemlist and a detailed view will create a detailed list.

How should I do this? Also to minimize the strain, I would prefer doing 1 master ASP page which will have the response.write scripting and which will give the user the data that he has requested.

Something like this... www.mydomain.com/target.asp?id=194&detailed=yes

Here, I can just update the database to which TARGET.ASP is linked to so that I can just update the ID number and the contents. I can link to this from the index or search page. I can assign individual ID numbers to each cities and detailed view to YES/NO...

Timely help will be highly appreciated...

Thanks in advance,
Sudarshan...



Sudarshan