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]

PHP Code:

$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]

PHP Code:

$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!

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


[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]

PHP Code:

$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 [DATE]1209324149[/DATE] at [TIME]1209324149[/TIME] ---------------

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

--------------- Added [DATE]1209325454[/DATE] at [TIME]1209325454[/TIME] ---------------

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

Thank you so much!!! I appreciate it.