last record

[runza]

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

 

[troester]

What is the "last" record? the one with the greatest id? or a special (maximum) date?

Do you want to show the list view with only this record or a details or form view?

Where did you try the calc element?

 

[runza]

hie
i would like display the last record in a article like this
http://www.gerontologie-rhone-alpes.fr/prochaine_journee_027.htm
i try content plug-in but it's not the solution
i try to use php ( as my skill improve) in a calc element
with an array may be
or pre-filter
but i don't achieve

phil

 

[sales2010]

Hello,

Try

Select MAX(id), other fields from....

 

[runza]

Pre-filters

i don't understand what does it mean "other fields from..."

i try this Pre-filters (image attached ) but it seem to doesn't work
philippe

 

[felixkat]

The calc would be something like....

$db =&JFactory::getDBO();
$db->setQuery("SELECT `date_time` , `departement` , `ville` , `nom` , `pdf` FROM `compterendues` ORDER BY `id` DESC LIMIT 1");
$row = $db->LoadRow();
return $row;

 

[runza]

it's ok but with this message *( see below) , i obtain this result

• La chute
• 74
• Annecy
• 86?me

i will try now to format this result in order to obtain a result like this http://www.gerontologie-rhone-alpes.fr/prochaine_journee_027.htm

* Warning: Attempt to assign property of non-object in /homez.541/associatri/www/rhonealpes/plugins/fabrik_element/calc/calc.php on line 410

 

[felixkat]

Did you install the calc manually from discover?

You may have to perform a Github update so your Fabrik files are in sync.