Сортировка товарах одного производителя. - sCatalog

<?php
/**
 * @version $Id$
 * @package    SCatalog
 * @subpackage Views
 * @author     EasyJoomla {@link http://www.easy-joomla.org Easy-Joomla.org}
 * @author     Constantine Poltyrev {@link http://bugs.rallycars.ru}
 * @author     Created on 14-Dec-09
 */

//-- No direct access
defined('_JEXEC') or die('=;)');
$ncols = $this->params->get( 'brand_num_columns', 2 );
?>
<h1 class="componentheading<?=$this->params->get( 'pageclass_sfx' )?>">
  <?=$this->escape($this->title)?>
</h1>
<div class="sc_brands">
	<?php
		  $n = 0;
		  foreach($this->data as $brand){
			 // if($n > 0 && $n % $ncols == 0)echo "</tr><tr>";
			  $n++;
		  ?>
			  <h2><?php echo $brand->title?></h2><?
			  $result_prod = mysql_query("SELECT id, title, short_desc FROM jos_scatalog_products WHERE `manufacturer_id`=$brand->id") or die("Invalid query: " . mysql_error());
			  while($row_prod = mysql_fetch_array($result_prod, MYSQL_NUM)) {
		
		  echo '<h2 class="prod_title">'.$row_prod[1].'</h2>
			<span class="prod_short_desc">'.$row_prod[2].'</span>';
		  }
 		 }
?>
</div>
<form name="adminForm" method="post">
  <?php echo $this->pagination->getListFooter();?>
</form>