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

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

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

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

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

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 m

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

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

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

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