lukelukeluke
Technical User
Hi there!
I have a little script which looks like the following:
This gives me the row "kat2" out. As you see i got a <br> there so it gives me a list of things from the mysql table vertically, lets say these:
Apple
Tree
Telephone
Apple
Computer
Tree
You can see that there are entrys which are the same. But i would like to show every entry only one time also if it is more than one time into the database. How can i do that?
Thanks!
I have a little script which looks like the following:
Code:
<?php
$kate = "'Webserver'";
$sql = 'SELECT * FROM knowledgebase_artikel WHERE kat1 LIKE '.$kate;
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) { echo "$row[kat2]<br>";
}
?>
Apple
Tree
Telephone
Apple
Computer
Tree
You can see that there are entrys which are the same. But i would like to show every entry only one time also if it is more than one time into the database. How can i do that?
Thanks!