mattm1712 Posted May 12, 2012 Share Posted May 12, 2012 i am making a comparison site for products say i have a table ! A ! B ! C ! ---------------------------------------------------------------------- product 1 ! 1.34 ! 2.78 ! 7.90 ! ---------------------------------------------------------------------- product 2 ! 1.56 ! 3.90 ! 8.00 ! ---------------------------------------------------------------------- product 3 ! 1.22 ! 2.99 ! 9.00 ! ---------------------------------------------------------------------- product 4 ! 1.09 ! 3.00 ! 8.50 ! ---------------------------------------------------------------------- say i wanted to buy product 1 and 2 from the cheapest company A/B or C how would i go about doing this ? any guidance would be helpful cheers matt Link to comment https://forums.phpfreaks.com/topic/262448-selecting-which-company-is-cheaper-if-i-have-multiple-products/ Share on other sites More sharing options...
Failing_Solutions Posted May 12, 2012 Share Posted May 12, 2012 Hi Matt, You could easily select the products with SQL, but what happens after that is a little unknown. Are you trying to direct customers to other peoples sites ? Allow them to buy it on your site? Are you factoring in the shipping cost? If product 1 from Company A is more then Company B, but Product 2 is cheaper at Company A who has cheaper shipping rates, then it "may" make more since to buy both products at company A. Link to comment https://forums.phpfreaks.com/topic/262448-selecting-which-company-is-cheaper-if-i-have-multiple-products/#findComment-1344995 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.