147941 XML, MySQL Travel site coding

I need to create a [login to view URL] affiliate website. [login to view URL] provides static data database and dynamic XML access for real-time search. Me website should be self-contained without any outside links to the affiliate provider. All pages have to be MySQL based dynamic php and look static to search engines. The supplier provides static data in a delimited text file. I need the data to be automatically entered to a MySQL database and a report to be generated about any database changes. The updates have to be scheduled and automatic. I am planning to add a travel blog, picture gallery and travel e-zine to basic futures, provided by ian.com. There are more things to think about, but let us start from what is already described. Happy bidding. mammon.