// display data in rows and columns in a table following code can be used
echo "<TABLE bordercolor=#FF00EE border=1 cellpadding=8>";
$num=4;
connect_db();
$result=mysql_query("SELECT * FROM ".TBL_LINKS." ORDER BY ABS(hits) DESC LIMIT ".$max_links);
while($row = mysql_fetch_assoc($result))
{
if($num%4===0) echo "<tr>";
echo "n<td width=150><A HREF="".dc_siteurl."/".$row['slug']."" target=_new title="".$row['name']."">".$row['slug']."</A></td>";
if($num%4===4) echo "</tr>";
$num = $num+1;
}
mysql_close();
echo "</TABLE>";
Comments