ORDER BY id DESC LIMIT 1

we

webkruter 22 Dec, 2014

Dear Admins!
How i can select from database tabel 'test' ORDER BY id DESC LIMIT 1

example query "select * from #__test ORDER BY id DESC LIMIT 1 "

I need view in FrontList only end row from table. How i can do this?

Tnx

Max_admin 22 Dec, 2014

You can set the page limit under the "Frontend list" settings, and you can change the order field under the Model section!

Regards,
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.