Как вывести кол-во товаров, мин-макс цену и рандомную картинку - [VM2&3] Дизайн, оформление

<?php
$sql = "SELECT min(p.product_price) AS min_price, max(p.product_price) AS max_price, c.virtuemart_category_id AS category
FROM  jos_virtuemart_product_categories c LEFT JOIN jos_virtuemart_product_prices p
ON c.virtuemart_product_id = p.virtuemart_product_id
GROUP BY category";

$db = mysql_connect('hostname', 'username', 'password');
mysql_select_db('basename');
$res = mysql_query($sql);
$result = array();
$result2 = array();
if ($res){
while ($row = mysql_fetch_assoc($res)) {
	$result[$row['category']] = $row['min_price'];
	$result2[$row['category']] = $row['max_price'];
	}
}
$minprice = $result[$category->virtuemart_category_id];
$maxprice = $result2[$category->virtuemart_category_id];
?>

<?php echo $minprice; ?>
<?php echo $maxprice; ?>

...
$db = &JFactory::getDBO();
$db->setQuery($query);
...