Problem using Select MIN()

[fodder]

Hi Excuse my idiocy, but this is really frustrating me.

 

I want to select the row from a table that has the least value in a 'score' field.

 

For example using phpdmin the following returns the lowest score in the table

 

SELECT MIN( score ) FROM `table'

 

fair enough, however the following php :

 

$query="SELECT MIN(score) FROM ".$table;

$result = mysql_query($query);

echo mysql_error();

$num=mysql_num_rows($result);

echo $num;

 

while($row = mysql_fetch_assoc($result))

{

echo $row['score']."<br>";

}

 

simply returns 1 for the number of rows found, but nothing else, how do I access the result, i.e. lowest score.

 

thanks

[corbin]

SELECT * FROM table WHERE score = (SELECT MIN(score) FROM table));

 

Is the only thing I can think of to do it in 1 query, but there must be a better way....  Hrmm....

[fenway]

A derived table would work too.