Got this code example off of yahoo so consider the source. It works fine and pulls my results from my database except that it prints the results twice. How do I get this to only return the one value?
$currentAd2 = rand (0, 14);
$query = “SELECT towerurl FROM TOWER WHERE id=$currentAd2”;
$result = mysql_query($query);
while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print “$value”;
}
}
mysql_close($link);
?>