php/mysql question

Hello

In one of my databases i have a collumn called "tags" in the table "entrys" i wanted to ask how the SQL question would look like for PHP if i wanted to list all the tags in that collumn when accessing the php file? also, if there was several fields with the same tag it should not display duplicates, only one tag with name X once.

i hope someone could help me

 

SELECT DISTINCT `tags` FROM `entrys`.

Then just query and get the rows.

 

<?php
//be sure to have db credentials included
$sql = "select distinct tags from entrys";
$rs = mysql_query($sql);
while($row=@mysql_fetch_object($rs)){
print "$row->tags || ";
}
?>

 

Thank you. I got one question tough. right now it displays the output like this

mspaint || wow || Anime,Air Gear || Anime,Dokuro-chan ||

Is it possible to make it only display the tag "anime" once? and the same thing for all tags. in the output.

 

IT needs an explode and add them into array then filter array to show unique vars only but its more to work - have the idea and develop it