Jump to content

searls03

Members
  • Content Count

    906
  • Joined

  • Last visited

Community Reputation

1 Neutral

About searls03

  • Rank
    Prolific Member

Contact Methods

  • Website URL
    http://troop078.net46.net

Profile Information

  • Gender
    Not Telling
  1. I am trying to run two queries within one I guess you could say. What I am trying to do is build a scoring system where each person gets two chances. The least number is their best. What I need to have happen is for the php query to select the smallest number for each person, then display the 3 names of the people with the 3 smallest numbers. I am guessing I need to use a query like this to get the smallest number for each person: $sql = mysql_query("SELECT LEAST(MIN(COL1),MIN(COL2))FROM yourtable;"); but after this I am stumped as to how to make it display the names associated with the 3 smallest numbers. Can anyone help me out?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.