Hi,

I am interested in starting a small price comaprison website in my local area. The site should compare prices from 20 suppliers, selling an identical product in 4 different quantities and some suppliers only deliver to certain post/zip codes.

What would be the best way to set up this database in phpmyadmin? table for supplier names with IDs, then table with prices per quantity per supplier and then table detailing post/zip codes each supplier delivers to?

I also need advice around the customer interface. I'd like 3 dropdown lists on my home page, list 1 gives county options, list 2 would then open in different frame showing applicable post/zip codes based on county selected in list 1 and finally list 3 opens in another new frame giving quantity options. And based on the choices selected in each dropdown list, a new page opens detailing the cheapest suppliers in ascending order for the applicable quantity in the customers area. How would you go about doing this?

I'm pretty new to php and mysql but i've got a lot of time on my hands and any advice would be greatly appreciated.

Regards... Sparatacus

Hi kooia,

I'd prefer advice on the technical stuff. If you were setting up this site, how would you tackle it? What would your step-by-step approach be?

Regards... Sparatacus

Hi,

I'm a complete newbie at web design, but have come up with a business idea for a simple price comparison website in my local area. I've registered the domain name and have a web hosting provider, so I just need a little advice about getting this project off the ground.

The site should provide details of product prices from 20 suppliers, who all supply this product in 4 different quantities and some suppliers only deliver to certain areas.

Front page should have 3 drop down lists for a. area, b. zip/post code and c. quantity required. Would prefer if lists a and b were linked, ie. select area 1 gives 5 zip codes in list b, whilst area 3 gives 9 zips in list b.

And obviously tables in a database where supplier info, supplier prices, zip/postcodes suppliers deliver to etc are stored so the cheapest suppliers based on the users choices at the first page are generated.

I know this is probably very simple for you guys, but I havent a clue where to start. I'd really appreciate any advice or guidance you could give me. I know this will take a long time to implement, but I've got time on my hands and I want to do a good job at this.

Regards... Sparatacus