[mysql]select di un solo record

[gm]

<?php

$res = mysql_query("SELECT MAX(campo1) FROM tabella1");

$row = mysql_fetch_array($res);

echo $row[0];

// Oppure, creando un alias

$res = mysql_query("SELECT MAX(campo1) AS max FROM tabella1");

$row = mysql_fetch_array($res);

echo $row['max'];

?>