Pulling the value from a MAX()

[foxrings]

How do you pull the value from a MAX() function

$query = 'SELECT Product_id from Products WHERE ...';

$result = mysql_db_query("Odell_Computer_Sales", $query, $link);

$row = mysql_fetch_array($result);

$max = $row['???'];

[[deleted]]

change your query to

SELECT max(column) AS myname FROM ...

now your value will be available as $row['myname']

[foxrings]

Right.. smack
Of course..

Only been doing this for a few weeks now...

Thanks! =)