max - TagMyCode

Please login or create account to add a snippet.

Follow @TagMyCode

Language: PHP

Posted by: Jorge Alcalá

Added: Sep 19, 2018 12:18 AM

Modified: Oct 22, 2018 11:11 PM

Tags: t_query

$consulta = 'SELECT MAX(%s) AS max FROM %s WHERE clacliente = ' . $cliente;
$consulta = sprintf($consulta, DocumColectivosAdjuntosPeer::NUMERO, DocumColectivosAdjuntosPeer::TABLE_NAME);
$sentencia = $conexion->prepareStatement($consulta);
$resultset = $sentencia->executeQuery();
$resultset->next();
$numero = $resultset->getInt('max') + 1;