PHP coding a price comparaison tool
- by Tristan
Hello,
it's the first time I developp such tool you all know (the possibility to compare articles according to price and/or options)
Since I never did that i want to tell me what do you think of the way i see that :
On the database we would have :
offer / price / option 1 / option 2 / option 3 / IDseller / IDoffer
best buy / 15$ / full FTP / web hosting / php.ini / 10 / 1
.../..../....
And the request made by the client :
"SELECT * FROM offers WHERE price <= 20 AND option1 = fullFTP";
I don't know if it seems OK to you.
Plus i was wondering, how to avoid multiples entries for the same seller.
Imagine you have multiple offers with a price <= 20 with the option FullFTP for the same seller, i don't want him to be shown 5 times on the comparator.
If you have any advices ;)
Thanks