Tried it and still had duplicates. Am I missing something?
:-/ Thanks for your help by the way!
PHP Code:
$entries = $db->query_read("SELECT DISTINCT tags FROM " . TABLE_PREFIX . "journal_entries WHERE journal_id =" . $j." AND tags IS NOT NULL AND tags <> '' ORDER BY tags ASC LIMIT 200");
while ($entry = $vbulletin->db->fetch_array($entries))
{
$array = strtolower($entry['tags']);
$array = explode(',', trim($entry['tags']));
$tmparray = array();
foreach ($array AS $value)
{
$exploded = explode(',', $value);
foreach ($exploded AS $explode)
{
$tmparray[] = $explode;
}
}
$kwords = array_unique($tmparray);
foreach ($kwords AS $keyword)
{
$keyword = trim($keyword);
eval('$blogtags .="' . fetch_template('blogtag') . '";');
}
}