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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.