[SOLVED] [Q]How do i prevent ouputting the same value in a while loop?

[DieterDaems]

For now this is all i got.

Because i have no idea, how to prevent outputting the same value.

And still continueing the loop.

Can anyone help me, or point me in the right direction?

 

with friendly greetings, Dieter

 

               $myDb->connect();
		$sql  = "SELECT * FROM 
		`winelist`, `winemakers`
		 WHERE (`winelist`.`winemakerid` = `winemakers`.`id`)
		 ORDER BY 
		 winecountry, winetype, winename_sub, wineyear ";
		 $query = mysql_query($sql) or die("Query failed: " . mysql_error());
		 $result = mysql_fetch_array($query);
	$myDb->close();

			echo "<h3 class='menuheader expandable'>Per Winemaker</h3>";
  				echo "<ul class='categoryitems'>";
  			while ($result = mysql_fetch_array($query)){
  							
  				$makername = htmlentities($result['makername']);
			echo "<li><a href='wines.php?winemaker='$makername'>$makername</a></li>";
  			}
  				echo "</ul>";

[jon23d]

Use DISTINCT or GROUP to make your life easier.

[purpleshadez]

Use DISTINCT or GROUP to make your life easier.

This would be a slight mod of your SQL statement

$sql  = "SELECT * FROM
         `winelist`, `winemakers`
          WHERE (`winelist`.`winemakerid` = `winemakers`.`id`)
          GROUP BY 
          fieldName 
          ORDER BY
          winecountry, winetype, winename_sub, wineyear ";

[DieterDaems]

thx