Re: MAX on a query.

$dataobject->selectAdd('MAX(id) as id '); The Php_kid wrote:

Hi There is a way to make a "SELECT MAX(id) FROM Lotes" with DataObjects ? At the momment I'm getting last result with DB: <?php require_once('DB.php'); // get DSN from DataObjects config File. $options=parse_ini_file($_SERVER['DOCUMENT_ROOT']."/classes/jalilstamps.ini" ); $dsn=$options['database']; $db = DB::connect($dsn); if (DB::isError($db)) { die ($db->getMessage()); } $sql = "SELECT MAX(id) FROM Lotes"; $result = $db->query($sql); $db->disconnect(); $last_id=$result->fetchRow(); $new_id=$ultimo_id[0] + 1; ?> Thank you ! Regards mac -- ...ThE PhP_KiD.