Re: [PHP] People who bought this also bought (amazon style) functionality...logic problem

2006-09-27 Thread Ryan A
Warning, this email's a bit long You have a User table and a Product table, then a linking table that joins users with products that they have bought. Hey David,Curt,Richard! Thanks for replying. Looks like I will really have to brush up on my Sql, been using lazy sql for a

[PHP] People who bought this also bought (amazon style) functionality...logic problem

2006-09-26 Thread Ryan A
Hey all, I want to write a module for xcart (a commercial 'shopping cart') which would be like what Amazon.com offers when you go to shop on their site... when you click on a product to see its details you get a little box below that recommends more products based on what others have purchased

Re: [PHP] People who bought this also bought (amazon style) functionality...logic problem

2006-09-26 Thread David Tulloh
You have a User table and a Product table, then a linking table that joins users with products that they have bought. Given product A you get all users {B} who have bought product A, you then get a list of all products {C} that they have bought. You group {C} by product and get a count, order by

Re: [PHP] People who bought this also bought (amazon style) functionality...logic problem

2006-09-26 Thread Richard Lynch
On Tue, September 26, 2006 7:18 am, Ryan A wrote: I want to write a module for xcart (a commercial 'shopping cart') which would be like what Amazon.com offers when you go to shop on their site... when you click on a product to see its details you get a little box below that recommends more

Re: [PHP] People who bought this also bought (amazon style) functionality...logic problem

2006-09-26 Thread Curt Zirzow
On 9/26/06, Richard Lynch [EMAIL PROTECTED] wrote: On Tue, September 26, 2006 7:18 am, Ryan A wrote: I want to write a module for xcart (a commercial 'shopping cart') which would be like what Amazon.com offers when you go to shop on their site... when you click on a product to see its