#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    11
    Rep 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.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    10
    Rep 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...

Similar Threads

  1. Mail with attachment does not work through cron job
    By paCkeTroUTer in forum PHP Development
    Replies: 2
    Last Post: December 8th, 2003, 08:59 PM
  2. What's the biggest contracting job you've had?
    By bcyde in forum Dev Shed Lounge
    Replies: 5
    Last Post: October 2nd, 2003, 10:35 AM
  3. timeout for cron job - pls help!
    By keesiewf in forum UNIX Help
    Replies: 2
    Last Post: August 6th, 2003, 01:36 PM
  4. Replies: 5
    Last Post: February 21st, 2003, 12:25 AM
  5. Finding favourites: tough job
    By Abe Facciazzi in forum PHP Development
    Replies: 0
    Last Post: April 16th, 2000, 11:05 AM

IMN logo majestic logo threadwatch logo seochat tools logo