<?php
global $userdata, $aidlink, $locale, $db_prefix, $theme_width, $result;
$kategorijos_id = 3;
$rezas = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_draft='0' and news_cat='$kategorijos_id'
ORDER BY news_reads DESC LIMIT 0,1"
);
echo "<table width='0' cellspacing='0'>\n<tr>\n";
if (dbrows($rezas) != 0) {
while($data = dbarray($rezas)) {
echo"<tr>
<td>
<table cellspacing='0' cellpadding='0'>
<td width='0' height='0' style='padding-left: 10px; padding-top: 40px;'>
<img src='".$data['screenshot1']."' width='258' height='115'/></a>
</td>
<td style='padding-left: 5px; padding-top:35px; padding-right: 15px;'>
".trimlink($data['news_news'], 380)."
</td>
</tr>
</table> ";
}
echo"</tr>";
echo "</tr></table>\n";
}
?>