Find minimum from a query

programming
1

Hi there.

I am trying to find the minimum value of the results of a query but apparently, I’m still miles away from that.

I’ve tried this:


$query = "SELECT MIN(general) FROM score";
$result = mysql_query($query);
echo "Minimum score is: ".$result;

Apparently, this doesn’t work. I’m trying to put a the results of the query into an array then use the min function of PHP to find the minimum value but I still can’t figure out how.

Can anyone help me?

Thanks in advance.