how to display picture based on their popularity

Discussion in 'PHP' started by kwayug, Mar 29, 2007.

0
  1. #1
    i have created a photo sharing system, and i want the viewer to rate them by giving them a hit range from 0-10 based on quality of the picture. atleast 5 of the picture with most vote are displayed on the home page. this should change always.
     
    kwayug, Mar 29, 2007 IP
  2. srobona

    srobona Active Member

    Messages:
    577
    Likes Received:
    57
    Best Answers:
    0
    Trophy Points:
    88
    #2
    "select * from TABLE_NAME order by PICTURE_VOTE desc limit 0,5";

    This code will select 5 images from DB which get most votes.

    anything else?
     
    srobona, Mar 29, 2007 IP