Database: Max Value

Jump to bottom Edit New page

Matthew McNaney edited this page Mar 9, 2017 · 3 revisions

$db = \phpws2\Database::getDB();
$tbl = $db->addTable('table_name',null, false);
$max_column = $tbl->getField('sort_column_name');
$db->addExpression('max(' . $max_column . ')', 'max');
$max = $db->selectColumn();
echo (int)$max;