hie
i find a way to display the last record of a table from the menu link
i know that i can use a limit 1 on a sql query and use the prefilter
but i don"t achieve it
i use a calc element without success
$db =& JFactory::getDBO();
$db->setQuery("SELECT `date_time` , `departement` , `ville` , `nom` , `pdf` FROM `compterendues` LIMIT 1");
$rows = $db->loadObjectList();
philippe
i find a way to display the last record of a table from the menu link
i know that i can use a limit 1 on a sql query and use the prefilter
but i don"t achieve it
i use a calc element without success
$db =& JFactory::getDBO();
$db->setQuery("SELECT `date_time` , `departement` , `ville` , `nom` , `pdf` FROM `compterendues` LIMIT 1");
$rows = $db->loadObjectList();
philippe