Get Max From Array

If a run a query like "SELECT revision FROM table WHERE unitno = 'unitno'", how do I return each of the values into an array?

Also, once the values are in an array, I want to get the max value. Am I right in thinking I do this by MAX(revision)?

Cheers, Jo

I thought that this might work but it doesn't. Can anyone help?

$newrevision = max(list($key, $value))+1;

Got it. Thanks anyway. If anyone wants the code it's:

//find latest revision
$get_result = mysql_query("SELECT basicrevision FROM trialBasic WHERE unitno='$unitno'");
$rev=0;

while($row=mysql_fetch_row($get_result))
{
  if($rev<$row[0])
       $rev=$row[0]; 
}
$rev++;