MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Iron Speed
Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old April 18th, 2000, 03:15 AM
Abe Facciazzi Abe Facciazzi is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2000
Posts: 11 Abe Facciazzi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
(Already tried on the PHP message board: no answers)

First of all I believe this is a very tough issue, so thanks in advance to everyone who will try to help. I have a MySQL database that handles a quizzes high scores. Database has name of the quiz, score and name of the player. At the end of every quiz I would like to recommend the player other quizzes, based on what other players played. This is something similar to what Amazon does with books and videos. My aim, I think, should be to have a DISTINCT list of all players who played a particular quiz and then get a DISTINCT list of all quizzes played by those players. That way I could tell which quizzes played the players who played a particular quiz. I could then suggest the player who played that particular quiz what other quizzes he may like, based on general interests. The last list should also have a COUNT, so that I can tell the 3-4 most played quizzes without listing them all.
1) Is there a way to do this using a PHP file?
2) Is this the best way to suggest a player what other players who played the same quiz he played like?
Thanks again in advance for any help.

Reply With Quote
  #2  
Old April 18th, 2000, 05:20 AM
tony styles tony styles is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2000
Posts: 10 tony styles User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
The trick to solving this simply, appears to be in specifying the users interests clearly and simply, in a manner easy to judge what they like. Sticking to simple choices, and keywords will make it a lot easier.
Once the data is in a nice format each should be faily easy to generate some selects to determine suitability...

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > Finding favourites: tough job


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway