I want to display a list of my categories. Like this:
- Cat 1
- Cat 2
- Cat 3
and so on.. the problem is, that there are several categories named e.g "Cat 1", so the list will look like this:
- Cat 1
- Cat 2
- Cat 1
- Cat 3
- Cat 1
How can i ensure there is only one of each category displayed?
I am doing this with php like this:
$abfrage = "SELECT * FROM Entries WHERE modulationstyp = 'Frequenzgespreizt'";
$ergebnis = mysqli_query($db, $abfrage)
OR die("Error: $abfrage <br>".mysql_error());
while($row = mysqli_fetch_object($ergebnis))
{
echo "<li> $row->modulation </li>";
}
mysqli_close($db);
?>
This is for one Category..