i have a ‘meta’ field in my blog which when i enter a blog i enter key words ‘rant php mysql’ etc… using a space as an identifier. currently i i haven’t been doing anything with this data. but now i want to split the words up and display them on the page in a list.
sounds easy…
but heres the bit i cant get my head round i don’t want duplicate data in the list.
i.e. more than one of my blogs will contain PHP or MYSQL but how would i stop these from looping again
[code=php]
$query = “SELECT meta FROM `blog`”;
$result = mysql_query($query) or die();
while ($row = mysql_fetch_assoc($result))
{
some function???
{
echo ‘<li><a href=”/blog/’.$meta.'”>’.$meta.'</a></li>’;
}
}
thanks in advance