Алфавитная разбивка производителей - [VM1] Модификации и хаки

<form id="munufsort" method="POST">
<button class="munufsort" name="submit" type='hidden' value=2><span>A</span></button>
<button class="munufsort" name="submit" type='hidden' value=3><span>B</span></button>
<button class="munufsort" name="submit" type='hidden' value=4><span>C</span></button>
<button class='munufsort' name='submit' type='hidden' value=5><span>D</span></button>
<button class='munufsort' name='submit' type='hidden' value=6><span>E</span></button>
<button class='munufsort' name='submit' type='hidden' value=7><span>F</span></button>
<button class='munufsort' name='submit' type='hidden' value=8><span>G</span></button>
<button class='munufsort' name='submit' type='hidden' value=9><span>H</span></button>
<button class='munufsort' name='submit' type='hidden' value=10><span>I</span></button>
<button class='munufsort' name='submit' type='hidden' value=11><span>J</span></button>
<button class='munufsort' name='submit' type='hidden' value=12><span>K</span></button>
<button class='munufsort' name='submit' type='hidden' value=13><span>L</span></button>
<button class='munufsort' name='submit' type='hidden' value=14><span>M</span></button>
<button class='munufsort' name='submit' type='hidden' value=15><span>N</span></button>
<button class='munufsort' name='submit' type='hidden' value=16><span>O</span></button>
<button class='munufsort' name='submit' type='hidden' value=17><span>P</span></button>
<button class='munufsort' name='submit' type='hidden' value=18><span>Q</span></button>
<button class='munufsort' name='submit' type='hidden' value=19><span>R</span></button>
<button class='munufsort' name='submit' type='hidden' value=20><span>S</span></button>
<button class='munufsort' name='submit' type='hidden' value=21><span>T</span></button>
<button class='munufsort' name='submit' type='hidden' value=22><span>U</span></button>
<button class='munufsort' name='submit' type='hidden' value=23><span>V</span></button>
<button class='munufsort' name='submit' type='hidden' value=24><span>W</span></button>
<button class='munufsort' name='submit' type='hidden' value=25><span>X</span></button>
<button class='munufsort' name='submit' type='hidden' value=26><span>Y</span></button>
<button class='munufsort' name='submit' type='hidden' value=27><span>Z</span></button>
</form>

<?php
$posted = $_POST['submit'];
if ($posted != '') {
$db =& JFactory::getDBO();
$query = "SELECT a.manufacturer_id, a.mf_name, c.mf_category_name FROM #__vm_manufacturer a, #__vm_manufacturer_category c WHERE c.mf_category_id =a.mf_category_id AND c.mf_category_id='$posted'";
$db->setQuery( $query );
$product = $db->loadObjectList();
}
?>
<?php if ($product) foreach ($product as $row){?>
	<div>
		<a class="sn" href="index.php?option=com_virtuemart&page=shop.browse&manufacturer_id=<?php echo $row->manufacturer_id?>"><?php echo $row->mf_name?></a>
	</div>
	<?php }else{
echo "В данной категории нет производителей";
}
?>

-- Структура таблицы `jos_vm_manufacturer_category`
--

CREATE TABLE IF NOT EXISTS `jos_vm_manufacturer_category` (
  `mf_category_id` int(11) NOT NULL auto_increment,
  `mf_category_name` varchar(64) default NULL,
  `mf_category_desc` text,
  PRIMARY KEY  (`mf_category_id`),
  KEY `idx_manufacturer_category_category_name` (`mf_category_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Manufacturers are assigned to these categories' AUTO_INCREMENT=28 ;

--
-- Дамп данных таблицы `jos_vm_manufacturer_category`
--

INSERT INTO `jos_vm_manufacturer_category` (`mf_category_id`, `mf_category_name`, `mf_category_desc`) VALUES
(1, '-default-', 'This is the default manufacturer category'),
(2, 'A', ''),
(3, 'B', ''),
(4, 'C', ''),
(5, 'D', ''),
(6, 'E', ''),
(7, 'F', ''),
(8, 'G', ''),
(9, 'H', ''),
(10, 'I', ''),
(11, 'J', ''),
(12, 'K', ''),
(13, 'L', ''),
(14, 'M', ''),
(15, 'N', ''),
(16, 'O', ''),
(17, 'P', ''),
(18, 'Q', ''),
(19, 'R', ''),
(20, 'S', ''),
(21, 'T', ''),
(22, 'U', ''),
(23, 'V', ''),
(24, 'W', ''),
(25, 'X', ''),
(26, 'Y', ''),
(27, 'Z', '');