Page 1 of 1
$db select max() from ..
Posted: Tue Feb 03, 2009 4:53 am
by crankshaft
Hi;
I am having trouble with the following queries which both return empty results in a UDT, although when I run them in phpmyadmin they work fine !
Code: Select all
$sql = "SELECT max(news_id) as 'next_no' FROM 'cms_module_news'";
$sql = "SELECT max(news_id) FROM 'cms_module_news'";
$db = &$gCms->db;
$dbresult = $db->Execute($sql);
$row = $dbresult->FetchRow();
print_r($row);
Any suggestions
Thanks
P
Re: $db select max() from ..
Posted: Sat Mar 14, 2009 10:45 am
by musicscore
Have you find a solution. I have the same probem
global $smarty;
$tpl_vars = $smarty->get_template_vars();
global $gCms;
$db = &$gCms->GetDb();
$naam = $tpl_vars['naam'];
$email = $tpl_vars['email'];
$telefoon = $tpl_vars['telefoon'];
$aanbod = $tpl_vars['aanbod'];
$advertentie = $tpl_vars['advertentie'];
$adres = $tpl_vars['adres'];
$plaatsnaam = $tpl_vars['plaatsnaam'];
$land = $tpl_vars['land'];
$type = $tpl_vars['type'];
$prijsklasse = $tpl_vars['prijsklasse'];
$vraagprijs = $tpl_vars['vraagprijs'];
$omschrijving = $tpl_vars['omschrijving'];
$perceel = $tpl_vars['perceel'];
$leefoppervlak = $tpl_vars['leefoppervlak'];
$afbeeldin1 = $tpl_vars['afbeelding1'];
$afbeelding2 = $tpl_vars['afbeelding2'];
$afbeelding3 = $tpl_vars['afbeelding3'];
$afbeelding4 = $tpl_vars['afbeelding4'];
$afbeelding5 = $tpl_vars['afbeelding5'];
$bestand = $tpl_vars['bestand'];
$akkoord = $tpl_vars['akkoord'];
$item_order = 1;
$active = 0;
$isdefault = 0;
$query = "SELECT MAX(ID) AS maxid FROM cms_module_woongazet_object";
$db->Execute($query);
echo "Maxid =" . $maxid;
Maxid returns empty.