a litle help with SQL query and PHP

hi everyone,

i have an SQL query where i'm selecting the manufacturers of my products. i want to create a "filter" where the visitors can separate the products by manufacturer that his want. this is my PHP code:

<?php $msql = mysql_query("SELECT manuf FROM products WHere cid='$cid' AND status=1 ORDER BY manuf");
	  while($mrow = mysql_fetch_array($msql)) {?>
      <a href="<?php echo "products.php?cid=".$cid."&manuf=".$mrow['manuf'];?>"><?php echo $mrow['manuf'];?></a><br><?php }?>

PHP:

My output from this SQL is this:

but i want to display one manufacturer for each similar rows. like that:

can anybody help me whith this?

 

try "select distinct manuf..." - that might do waht you want.....

 

thank you. it's working fine.