I have the following Query and PHP:
Code:
    $menulisting = $pdo->query("SELECT DISTINCT MK.menu_kaart_id, MK.menu_kaart_type_nl, MK.menu_kaart_type_en, MI.language_abbr, MI.menu_item, MI.menu_item_description, MI.menu_item_price, MI.menu_item_price_2 
	                        FROM menu_kaart MK
                                INNER JOIN menu_kaart_items MI ON MK.menu_kaart_id = MI.menu_kaart_id
                                WHERE MK.menu_kaart_id = $menu_id
                                AND   MI.language_abbr = '$language_abbr' "); 
	
    $menulisting->setFetchMode(PDO::FETCH_ASSOC);
	  
    while($row = $menulisting->fetch()) {
	  $menu_title = $row["menu_kaart_type_$language_abbr"];
      echo '<h1>'. $menu_title .'</h1>';
	}
But the menu_title is echod multiply the number of menu_items each menu_kaart_id has. As you can see am I using DISTINCT and have I tried RIGHT JOIN instead of INNER JOIN, but nothing is doing the trick. What should I change in this structure. Thank you in advance