// if batch product
$query = "SELECT * FROM batchproducts WHERE pr_id = ".mq($product['pr_id']);
$batch = mysql_fetch_assoc(mysql_query($query));
if ( $batch ) {
// we have a main item for batch
$query = "SELECT * FROM products WHERE ba_id = ".mq($product['ba_id'])." ORDER BY item ";
$result=mysql_query($query);
?>