gistfile1.php

$query2 = "SELECT * FROM vendor 
		   ORDER BY VendorName";

 if (!$vendorResult = @mysql_query($query2, $connection))
    showerror();


$template->setCurrentBlock("VENDORS");


while ($vendorRow = mysql_fetch_array($vendorResult))
{ 	
	
	
	if($vendorName != $vendorRow['VendorName']){
		$softwareTypeRowString = "<a href =" .'"';
		$softwareTypeRowString .= $vendorRow["VendorName"] . '"';
		$softwareTypeRowString .= ">";
		$softwareTypeRowString .= $vendorRow["VendorName"];
		$softwareTypeRowString .= "</a><br/>";
		$softwareTypeRowString .= "&#187; " . $vendorRow["VendorProductName"] . "<br/>";
	}

	if($vendorRow['VendorName'] == $vendorName){
		$softwareTypeRowString .= "&#187; " . $vendorRow["VendorProductName"] . "<br/>";
		
	}
	
	$vendorName = $vendorRow['VendorName'];
	
}

$template->setVariable("VENDORS_DROP_DOWN" , $softwareTypeRowString);
$template->parseCurrentBlock();