Joomla Templates Club 406,261 posts

[attilio_sal Friend attilio_salJoin date: May 2009Posts: 29Downloads:10Uploads:0 Thanks: 13]

#148919

Hi, i need to limit max number of lastest products to display with vmproductslide (for instance 20 lastest products).
How can i do this, perhaps from sql query?

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#333821

Hi attilio_sal

For the case, please open modulesmod_ja_vmproductslideja_vmproductslideapplication.php file, find following code section:

$query .= ($this->_typeproduct) ? (($this->_typeproduct == 1 ) ? ' AND p.product_special ="Y" ORDER BY p.product_name DESC ' : 'ORDER BY p.cdate DESC ') : 'ORDER BY p.product_name DESC ';

and change to:


$query .= ($this->_typeproduct) ? (($this->_typeproduct == 1 ) ? ' AND p.product_special ="Y" ORDER BY p.product_name DESC ' : 'ORDER BY p.cdate DESC ') : 'ORDER BY p.product_name DESC ';

$query .= " LIMIT 0, 20";

1 user says Thank You to JA Developer for this useful post

1. attilio_sal

[attilio_sal Friend attilio_salJoin date: May 2009Posts: 29Downloads:10Uploads:0 Thanks: 13]

#333847

Thanks, this is exactly what i needed

[spyros Friend spyrosJoin date: March 2007Posts: 1Downloads:0Uploads:0]

#346191

Hi i tried this code but when the slide ends in ie8 instead of showing the products in the slide it loads the main page in every product placeholder in the module. if you try to load the page in firefox when the slide ends the browser tries to reload the whole page and you get an blank page.

[Author]

Posts