Alpha Video Training
Results 1 to 3 of 3

Thread: 5 Star Rating System

  1. #1
    Member
    Real Name
    Joel Baxter
    Join Date
    Mar 2010
    Location
    Hamilton, Ontario
    Posts
    48

    Default 5 Star Rating System

    Hello,

    I am setting up a website to sell comic books for an independent publisher using Alpha Five and I was wondering how to set up my MYSQL database for SIGNED IN users to rate a comic book.

    So the general idea is that once a user signs in, he has access to rate comic books (but only one per comic) via a drop down box.

    The drop down box displays the field
    rateimage (which is just an image of stars) ie *****
    but puts a value of 0 to 5 from the rateid (field)


    Since multiple people will be rating, I would like an idea of how to average the rateid, and display the appropriate rateimage.

    Could someone tell me the most efficient way to set up my databases for that?

    Thank-You in advance!

    Joel

  2. #2
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,631

    Default Re: 5 Star Rating System

    You could use a numeric field w. dropdown values of 0 to 5. Then use a conditional image field to show 0 to 5 stars based upon the value of the numeric field. Fortunately Alpha has built in icons for 1 to 5 stars you can use. For 0 you could use some other icon.

  3. #3
    Member
    Real Name
    Joel Baxter
    Join Date
    Mar 2010
    Location
    Hamilton, Ontario
    Posts
    48

    Default Re: 5 Star Rating System

    Thank-You Peter! That is very helpful!

Similar Threads

  1. Flying Star Tabbed UI-- Great Start, Disasturess Finish LOL
    By bbscop in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 08-29-2010, 09:28 AM
  2. system menu - system toolbar
    By Doug Chanley in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-01-2003, 04:26 PM
  3. rating Alpha Five on the Intuit Web site
    By Richard Rabins in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-12-2003, 09:05 AM
  4. rating Alpha Five on the Intuit Web site
    By Richard Rabins in forum Alpha Five Version 4
    Replies: 0
    Last Post: 01-08-2003, 06:59 AM
  5. rating Alpha Five on the Intuit Web site
    By Richard Rabins in forum Announcements
    Replies: 0
    Last Post: 01-08-2003, 06:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •