I want to create something like this: http://tinyurl.com/yetw589

Basically you click on a campground site, and it gives you information about it, like: site description, pad description, and a picture. Obviously, the best way would to have all this information in a database. I did some research and found out how to import an excel sheet of data into a MySQL database. Perfect. So now I can call that information onto an HTML page.

But how do I give each campground it's own page without creating them manually? How could the pages be generated automatically? I'm not a PHP/MySQL wizard, so I'm kinda stumped. Can someone give me a push in the right direction?

You'd want to use Ajax technologies. Essentially that means a combination of JavaScript, CSS, and the DOM. With JavaScript you can make a request of the database and have your single page update with information from the database.

So you don't have to create a new page for each of those campsites. You'd create a div in that location that pulls information from the database and then use Ajax to call different information from the database when the map is clicked.

I hope that makes sense.

This is just basic php/MySQL. Read a tutorial on it, then you should be able to do this. Try the one on tizag.com