- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
$result = dbquery(
"SELECT a.tag_id, a.tag_name, a.tag_type, a.tag_tags, u.article_id, u.article_cat, u.article_7, u.article_6, u.article_8, u.article_subject, u.article_snippet
FROM ".DB_TAGS." a
LEFT JOIN ".DB_ARTICLES." u ON u.article_id=a.tag_name
WHERE a.tag_type = 'A' AND article_draft='0'
ORDER BY article_datestamp
DESC");
if (dbrows($result)) {
while ($data = dbarray($result)) {
if ($data['tag_tags']) {
$tags = explode(", ", $data['tag_tags']);
foreach ($tags as $values) {
if ($values == $tagname) {
echo "<tr><td class='tbl1'>";
echo "Статья: <a href='".BSFURL.article($data['article_id'])."' title='".$data['article_subject']."' class='side'><strong>".$data['article_subject']."</strong></a>"; if ($data['article_6']) { echo" (Язык: <b>".$data['article_6']."</b>) "; } if ($data['article_7']) { echo"(Тип: <b><a href='".BSFURL.articlesTypes($data['article_8'])."'>".$data['article_7']."</a></b>)";} echo"\n<br />";
echo nl2br(parsesmileys(parseubb($data['article_snippet'])))."<hr /></td>\n</tr>\n";
}
}
}
}
}