<?
$sqlquery = "SELECT * FROM text_ads where id = '$id' limit 0,1";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
if ($number < 1) {
echo "AD NOT FOUND";
exit;
}
else { ?>
<?
while ($number > $i) {
$url = mysql_result($result,$i,"url");
$i++;
$query = "UPDATE text_ads SET clicks=clicks+1 WHERE id='$id'";
$rs = &$conn->Execute($query);
$query = "UPDATE text_ads SET gclicks=gclicks-1 WHERE id='$id'";
$rs = &$conn->Execute($query);
}
header ("Location: $url");
}
?>