Seperate a value

[mokujin]

Hi, can you help me with seperating?

I have ex. this script:

// Get details
$sql = $vbulletin->db->query_read("
SELECT field1
FROM " . TABLE_PREFIX . "mytable AS mytable
");

if field1 has 2 words is seperating with a comma
ex. "word 1, word2",
How can I show for each word in template with <a href="myfile.php?do=word 1">word 1</a>, <a href="myfile.php?do=word2">word2</a>

Sorry for my bad English, I cant say better :mad:

[Opserty]

$query = $vbulletin->db->query_read("
SELECT field1
FROM " . TABLE_PREFIX . "mytable
");
while($row = $vbulletin->db->fetch_array($query))
{
$words = explode(',', $row['field1']);
foreach($words as $word)
{
echo '<a href="myfile.php?do='. htmlspecialchars_uni($word) .'">'. htmlspecialchars_uni($word) .'</a>';
}
}

[mokujin]

Oh thank you for your replying, but I need it in template. If I use your code it shows in top of the page :(

[RLShare]

You have to put the php code in a plugin that hooks at the proper location.

[Opserty]

Change echo
To:
$somevarx .=

Then use $somevarx in your template.

[mokujin]

Hi again,
I have now another problem with seperating (using foreach function)
If I have SELECTED 3 rows from Database.
From second and third row they will repeat what previous row has.

Something like this:

Row 1: mytext, text
Row 2: thisis, thetext
Row 3: someword, my word

Then in template shows:
1: mytext, text
2: mytext, text, thisis, thetext
3: mytext, text, thisis, thetext, someword, my word

I think you will understand what I mean, thanks for helping me :(