need to set feature listings

Discussion in 'MySQL' started by saturn100, Nov 3, 2011.

0
  1. #1
    I have a simple database and script
    It is designed to show restuarants based on location
    state-city

    It works fine but currently shows results in alphabetical order
    I want to change this so I can set feature listings (ie paid listings) at the top
    Is there a way to do this in phpmyadmin

    One this i was thinking of is adding a field called feature with the data yes or no
    and saying to show the yesies (sp?) first
    is this possible

    Thanks
     
    Last edited: Nov 3, 2011
    saturn100, Nov 3, 2011 IP
  2. georgiivanov

    georgiivanov Member

    Messages:
    62
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    25
    #2
    add column:
    `featured` TINYINT DEFAULT 0

    when you selected them add ORDER BY `featured` DESC
     
    georgiivanov, Nov 4, 2011 IP