Need Help with An Array

[noonespecial]

I have an array that looks kind of like this:

$array = array("rss", "rss, happy, total", "total, happy, yesterday");

Now what I'd like to do is remove all of the duplicates so I have one array that looks like this - just one element in each value.

$array = array("rss", "happy", "total", "yesterday");

How could I do this?

[Dismounted]

$array = array("rss", "rss", "happy", "total", "total", "happy", "yesterday");
$array = array_unique($array);

[noonespecial]

Yeah, but how do I get that first array?

It's already set as:

$array = array("rss", "rss, happy, total", "total, happy, yesterday");

That's in the database already, I can't just change it -- well, my question is, how do I change it to a way I can use array_unique.

[Dismounted]

$array = array("rss", "rss, happy, total", "total, happy, yesterday");
$tmparray = array();

foreach ($array AS $value)
{
$exploded = explode(',', $value);

foreach ($exploded AS $explode)
{
$tmparray[] = $explode;
}
}

$array = array_unique($tmparray);

[noonespecial]

Tried it and still had duplicates. Am I missing something?

:-/ Thanks for your help by the way!

$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') . '";');
}
}

[Dismounted]

Can you give me the value of "$entry['tags']"?

[noonespecial]

Maybe I'm making a mistake -- so here's the output (value of $entry['tags']) from the query I am running.

Thanks again.

[Dismounted]

$entries = $vbulletin->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
");

$tags = array();

while ($entry = $vbulletin->db->fetch_array($entries))
{
$tag_entry = explode(', ', strtolower(trim($entry['tags'])));
$tags = array_merge($tags, $tag_entry);
}

$tags = array_map('trim', $tag_entry);
$tags = array_unique($tags);

foreach ($tags AS $keyword)
{
eval('$blogtags .="' . fetch_template('blogtag') . '";');
}

[noonespecial]

Hmm, this only returned three results:

recommendation, avatar, ap related

--------------- Added 1209324149 at 1209324149 ---------------

However, removing "$tags = array_map('trim', $tag_entry);" seems to have done it.

--------------- Added 1209325454 at 1209325454 ---------------

Of course - sort() doesn't work on this -- but it seems to work for what I need!

Thank you so much!!! I appreciate it.