Please help!

[todayme]

Note the code below selects the exact row I am looking for but I need to get the value of the field Status

Could someone please show me whats going on, The code works well selects the write row but within that row I just need to get the value of the field Status.

 

$query = "select max(ID) from _Replies where LINKID = '$LeadID'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result) or die(mysql_error());

foreach($row as $key => $val) {


Print $row['Status'];

   echo "The highest value is: ".$key." with a value of ".$val;

}

[only one]

$variable = $row['thefeild'];