openside("Losowy artykuł");

$result = dbquery(

	"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta

	INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id

	WHERE ".groupaccess('article_cat_access')." ORDER BY RAND() LIMIT 1"



);

if (dbrows($result) != 0) {

	while($data = dbarray($result)) {

		$itemsubject = trimlink($data['article_subject'], 23);

[color=red]                $itemsnippet = trimlink($data['article_snippet'], 300);

		$itemsnippet = nl2br($data['article_snippet']);[/color]



		echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a><br>[color=red]$itemsnippet[/color] \n";

	}

} else {

	echo "<center>".$locale['004']."</center>\n";

}

closeside();