openside("5 Nyeste links");

require_once BASEDIR."maincore.php";

$qresult=dbquery("SELECT * FROM ".DB_WEBLINKS." WHERE weblink_cat !='4' ORDER BY weblink_datestamp DESC LIMIT 5");

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

echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";

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

echo "<tr>\n<td class='small' align='left'><img src='".THEME."images/bullet.gif' alt=''><a target='_blank' href='$data[weblink_url]' title='$data[weblink_name]' class='side'> ";

echo trimlink($data['weblink_name'], 27)."</a></td>\n</tr>\n";

}

echo "</table>";

}

closeside();







openside("5 Mest Viste Link");

$qresult=dbquery("SELECT * FROM ".$db_prefix."weblinks ORDER BY weblink_count DESC LIMIT 5");

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

echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";

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

echo "<tr>\n<td class='small' align='left'><img src='".THEME."images/bullet.gif' alt=''><a target='_blank' href='$data[weblink_url]' title='$data[weblink_name]' class='side'> ";

echo trimlink($data['weblink_name'], 27)."</a></td>\n</tr>\n";

}

echo "</table>";

}

closeside();



openside("5 Tilfældige Links");

require_once BASEDIR."maincore.php";

$qresult=dbquery("SELECT * FROM ".DB_WEBLINKS." WHERE weblink_cat !='4'  ORDER BY rand()  DESC LIMIT 5");

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

echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";

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

echo "<tr>\n<td class='small' align='left'><img src='".THEME."images/bullet.gif' alt=''><a target='_blank' href='$data[weblink_url]' title='$data[weblink_name]' class='side'> ";

echo trimlink($data['weblink_name'], 27)."</a></td>\n</tr>\n";

}

echo "</table>";

}

closeside();