How do I do this

[tml89]

I would like to make an onesite search engine that another website was using. Basically I want surfers to be able to "compare shop" for products on my site. For example the surfer comes to the site to review different products of the same genre. They may want to search the products by price, qty, model etc.(whatever is applicable to the product) How do I set up drop down menu or something similar so display any products that I would be promoting for a given affiliate. I would also have to be able to add or delete a given product etc. Thanks. Please PM to see a few sites to give an idea of what I had in mind.

[ska_demon]

Hi, Sounds like this is a job for mySQL. If you need to add and remove products easily and also filter your results to allow product comparisons I think an SQL database would probably do what you need. I am not too familiar with mySQL but it is quite easy to build a database with phpmyadmin. You can then query the database using SQL queries or even PHP. My partner employed someone from rentacoder who is buiding her a reasonably complex database. The best thing is its good and cheap.
This may not be the only solution but it is the only easy one I can think of at the moment.

ps. You could build the drop down menu in your webpages using the form objects required and then tie them to the database fields.

[tml89]

Where is a good place to get a beginner tutorial on MySql/Php?