rendered paste body<?php
$sel=mysql_query("SELECT AVG(VOT) AS RATING, ID_INTRARE, NUME FROM `voturi` WHERE CATEGORIE='imagini' GROUP BY ID_INTRARE ORDER BY RATING DESC LIMIT 10");
while($va = mysql_fetch_assoc($sel)) {
$ddd=mysql_query("SELECT NUME, CATEGORIE FROM `imagini` WHERE ID={$va['ID_INTRARE']}");
while($tr=mysql_fetch_assoc($ddd)) { $nume = substr($tr['NUME'],0,15); $categ = $tr['CATEGORIE']; }
echo "<tr>
<td valign=\"top\"><img src=\"images/dot_white.gif\" width=\"4\" height=\"4\" vspace=\"5\"></td>
<td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td><a class=\"txt_white_bold\" href=\"?cmd=imagini&cat={$categ}id={$va['ID_INTRARE']}\">{$nume}</a><span class=\"txt_white_bold\">
({$va['RATING']})</span></td>
</tr>
</table></td>
</tr>";
}
?>