jamesxg1 Posted November 26, 2009 Share Posted November 26, 2009 Hiya peeps, I am in a real muddle, basically im asking everyone if anyone knows the best way to make a comparison site, tutorials, advice anything. I don't know where to start i've tried and tried, what i need to do is make something like the following. Say I make 3 STORE ID's in a mysql database and add a product the product will need to be added to each store id with the diffrent prices so heres a example in the best way i can explain. Store ID's = 1,2,3 Product ID's = 1,2,3 Store id 1 - product id 1 - £1 Store id 2 - product id 1 - £100000 Store id 3 - product id 1 - £1000 Store id 1 - product id 2 - £10 Store id 2 - product id 2 - £10000 Store id 3 - product id 2 - £100000 Store id 1 - product id 3 - £10000000 Store id 2 - product id 3 - £1000 Store id 3 - product id 3 - £1000000 what i will need to do is query the DB with the product id's and run them throught the store id's and total all the prices EG. i send Product ID 1 & 2 i will need to get the total price of store 1,2,3 for that id and find the cheapest. Many thanks James. Link to comment https://forums.phpfreaks.com/topic/182984-how-would-i-go-about-making-a-compare-site-i-need-help-bad/ Share on other sites More sharing options...
jamesxg1 Posted November 26, 2009 Author Share Posted November 26, 2009 Im going insane peeps lol. Link to comment https://forums.phpfreaks.com/topic/182984-how-would-i-go-about-making-a-compare-site-i-need-help-bad/#findComment-965821 Share on other sites More sharing options...
jamesxg1 Posted November 26, 2009 Author Share Posted November 26, 2009 Bump. Link to comment https://forums.phpfreaks.com/topic/182984-how-would-i-go-about-making-a-compare-site-i-need-help-bad/#findComment-965885 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.