I have catalogs of data downloaded from Commission Junction, which I update monthly. These catalogs can be quite large. I need a script that can delete the old date in mysql, then upload the data into a MySql database. (I need to be able to create the database in mysql in the first place as well). Then I need to be able to create pages on the fly based on searches made from this database. I will also want to have the ability to paste this code into any site I create using XsitePro.
If a database has 10,000 entries I need to be able to have a home page, and the links to various groups of products based on certain search criteria. The end result is displayed for the user to view and select an affiliate link to my vendors site.
I also want to be able to generate static pages that can be used for various promotional reasons and as search engine bait. I need to be able to include h1 tags, keywords etc on any static or on the fly page generated by the database.
If you are interested I would like to see similar projects you've completed, plus I can send you a sample of what the .csv database looks like.
Thanks in advance.