Jump to content

Ordering of the Manufactures Block.


Recommended Posts

You must edit this:

		$sql = 'SELECT m.*, ml.`description`, ml.`short_description`
			FROM `'._DB_PREFIX_.'manufacturer` m
			LEFT JOIN `'._DB_PREFIX_.'manufacturer_lang` ml ON (
				m.`id_manufacturer` = ml.`id_manufacturer`
				AND ml.`id_lang` = '.(int)$id_lang.'
			)
			'.Shop::addSqlAssociation('manufacturer', 'm');
			if ($active)
				$sql .= '
			WHERE m.`active` = 1';
			$sql .= '
			GROUP BY m.id_manufacturer
			ORDER BY m.`name` ASC'.
			($p ? ' LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n : '');

In classes/Manufacturer.php

 

CHange the ORDER BY, of course. Although I think the don't have a 'position' order, and you can only order them by either name or id (logically of course)

Link to comment
Share on other sites

×
×
  • Create New...