Debug...

[zzz]

Hi, I'm trying to get the top most popular links in order. I have the following fields:

linkTable -- table name
linkName -- self explanatory table field
HitsOut -- field that currently tracks clicks out

andf here's what I'm cooking, but it doesn't work for me...

<?
$stats=mysql_query("select * from linkTable order by HitsOut DESC LIMIT 5");
$get_stats=mysql_fetch_array($stats);
$SiteName=$get_stats[linkName];
?>

<font color="#000000">
<? echo"$SiteName";?>
</font>

What am I doing wrong?

Thanks for any help!

[stolzyboy]

use this

<?
$query = "select * from linkTable order by HitsOut DESC LIMIT 5;";
$result = mysql_query($query);

while ($row = mysql_fetch_array)
{
echo $SiteName . "<br>";
}

?>