need some ideas/suggestions on the best way to query multiple things for my site..

[beloved__one]

okay...i'm rebuilding my arcade site to be a lot more dynamic and i'll be storying almost everything in a MySQL database. i've got hundreds of games and add about 5 a week so what would be the best way to create new pages for these? all pages need to be ".php". Each aspect of each game (image, description, flash file, instructions) will be stored in a database. Im not sure how this would work but it would be nice to make it where when a link to a game is clicked on it loads the aspects of the game (title, flash file, insructions, icon) into a template...that way i don't have to make a seperate page necessarily for every game...the php does it for me....any suggestions on a better way to do it will be gladly accepted...thanks!!

[tomhath]

You're on the right track, using a template is the way to go.

Try a few templating systems out first so you know what can be done with them and how they want the data. It might be easier and faster to store at least some as files on the server so you can put links on the page instead of pulling large amounts of data out of the database. Then all you need to store in the db is the file name or a URL that will be put in the template.

[beloved__one]

i looked at a few and all mention things about having to change the php.ini file and having access to PEAR....neither of which i can do....any other suggestions?