tourist info/accommodation website

[spiceweasel]

I am looking to compile a tourist guide for my town. I want to be able to hold listing data (text and pictures) in a database and create pages dynamically and also be searched by a number of different ways (location, accommodation type, price etc). I have very basic php/mysql knowledge and think it would be a good project to increase my knowledge + fun too! Are there and books/tutorials/websites that you can recomend and any tips you could offer/newbie mistakes i should watch out for.

 

Thanks Guys!