jamjam

OMG!! I'm totally confused now. Muddy_Funster, ignace I currently have developer environment set up on my local pc. Using the http://localhost/cityname as in example. Will one you guys create a php script combined with a basic html template. I don't mean to bother you with this kind of request, but I now think it will take me from ever to find my own solution . I will be enternal grateful.

The page that displays that city information will be have the same format for all cities. So a basic html template will be ideal for the solution. Muddy_Funster I am interested to know how this will change your original solution.

Noted I have been comparing Workbench and Navicat. I was leaning towards Workbench as its community supported and free application but you as you mentionend Navicat. I shall consider that again.

Thanks for the recommendation. But I don't think I will be using a CMS like the ones you suggested. I plan to use Dreamweaver CS4 to maintain the parts of the website that are static html and once I have figured out a solution to my problem I will update the database using MySQL Workbench. Do think this is good approach?

Thanks Muddy_Funster Although I don't understand everything you said as I am so new to PHP. I now know that my original request is possible. So I am going to study hard to figure how to implement your solution. I will be back if I get stuck though. Thanks again

Thanks for the quick reply I am currently studing PHP and Mysql basics. I am confident of administering the site when it is up running. The reason I asked this question is that. It is critical to the workings of my site. I do not want my visitors to fill any forms or select check boxes. I just need them to click links. I can't find a reference to this solution so I thought I ask you guys. Please give more pointers into how a such solution would work. I will really Appreciate it. Thanks

Hello I am new to the world of creating dynamic web pages using PHP and Mysql. I want to create a new web site. I could just create this website, the good old way using a html editor and upload it to a webserver. Because this website will contain a huge amount of pages and it would be impossible to maintain using static html, such approach will also make it difficult to do regular updates. I want to store the sites information on a database, hence why I am exploring the dynamic route. Unlike most dynamic websites. I do not want the sites visitors to fill in forms, select drop boxes or anything like that to be able to access the database. Suppose my site was a travel-site that display’s information to visitors when they click a city link. Like his. http://www.travel.com/london http://www.travel.com/paris http://www.travel.com/tokyo Using static html I would simply upload a page for these cities to the correct location and that’s it. I want to achieve the same thing dynamically with the cities information been retrieved from the database depending on which link was clicked. So basically the PHP code should query and return a result from the Mysql database using the city name in the url. Is this possible? and if so how would I go about achieving this. If anyone can provide a PHP script that I can adapt that would be awesome. Thanks