This sounds a lot harder than it is, all you have to do is first of all make some space ion your db then you need to cache searches that users have done. Store the group of searches for unique users, then if someone does a search match it against the cache and pop up all items which were retrieved by the other cached searches for the other id's (you can build up the most popular items if there are lots of matches).. Amazon also caches your own searches and starts displaying groups of products which they know you were interested in and related products, I usually find them spot on so their logic is very good - it is bad for the credit card though :( Cheers Simon -----Original Message----- From: Maxim Maletsky [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 16:42 To: Randum Ian Cc: [EMAIL PROTECTED] Subject: Re: [PHP] People who searched this also searched this!
Gezz... This REALLY depends on your database design. You might want to track item IDs and then store them together. There is a bit of logic play on this one though.. -- Maxim Maletsky [EMAIL PROTECTED] www.PHPBeginner.com // where PHP Begins On Sun, 13 Oct 2002 18:15:16 +0100 "Randum Ian" <[EMAIL PROTECTED]> wrote: > Hi guys, > > Does anybody have a working example of doing the lists of 'People who > searched this also searched this!' that I see on Amazon and other > websites. > > Any help much appreciated! > > Randum Ian > [EMAIL PROTECTED] > DJ / Reviewer / Webmaster, DancePortal (UK) Limited > DancePortal.co.uk - Global dance music media > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php