[SOLVED] Select the row id of the minimum value of a given column

[ninedoors]

I would like to be able to select the row id of a given column that has the minimum value in that column.

 

So if I had a column named darts with values (0, 4, 6, 2, 0, 5, 7) in it.  How do I select the row id (row_id)for one of the columns with 0 in it.  Right now I am trying this but it isn't working:

 

$query = "SELECT row_id, MIN(darts) FROM schedule_temp GROUP BY row_id";

 

I understand why it isn't working but is there a mysql function that does this or do I have to pull out all the values and compare them in the script?

[ninedoors]

Wow, I'm dumb.  I guess I could jsut use ORDER BY and use the first record returned.