Some examples:
random, staff, inside
random
drew
NULL
Quote:
tags varchar(255) latin1_swedish_ci Yes NULL
|
From PHPMyadmin, if this helps.
PHP Code:
$entrys = $db->query_read("SELECT * , tags IS NULL AS isnull FROM " . TABLE_PREFIX . "journal_entries WHERE journal_id =" . $vbulletin->GPC['j']." ORDER BY isnull ASC, tags ASC");
while ($entry = $db->fetch_array($entrys))
{
if ($entry['tags'])
{
$kwords = explode(',', trim($entry['tags']));
$entry['tags'] = '';
foreach ($kwords AS $keyword)
{
$keyword = trim($keyword);
$entry['tags'] .='<a href="/journal.php?' .$vbulletin->session->vars['sessionurl']. 'do=showjournal&tag='.$keyword.'&j='.$j.'">' .$keyword. '</a>, ';
}
$entry['tags']= substr_replace($entry['tags'],'',-2);
}
}
Also doesn't work.
Edit:
Do I need to somehow add "commas" to the end of the other values?
I am so lost..
Someone, please help.