Code: Select all
<?
echo "<table width="700" height="85" cellpadding="0" border="1" cellspacing="0">";
echo "<tr><td> id </td><td> URL </td><td> Hits</td>";
$get_links= mysql_query("SELECT * FROM links ORDER BY id ASC");
while($rows = mysql_fetch_row($get_links))
{
while($myrows = mysql_fetch_assoc($get_links))
{
//now print the results:
$id= $myrowsї'id'];
$link= $myrowsї'url'];
$hits= $myrowsї'count'];
//print results.
echo "<tr><td>". $id . " </td><td> " .$link. " </td><td>". $hits . "</td>";
}
};
echo "</table>";
?>