LIMIT Clause

broberts 11 Sep, 2008
I'm trying to use a LIMIT in the WHERE SQL section and getting the message "Warning: Invalid argument supplied for foreach() in C:\...\Joomla15\components\com_chronoconnectivity\chronoconnectivity.html.php on line 137". The end of this section is

ORDER BY lprice 
LIMIT 50
Max_admin 11 Sep, 2008
Hi broberts,

I don't think you can use the LIMIT there now, maybe I will add this feature, for now you need to add WHERE statement only because I think this SQL is used later in another SQL statement which has LIMIT!

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.

VPS & Email Hosting 20% discount
hostinger