I have the following code to select and display banners in 3 predefined locations. The code freezes.
$url = 'http://';
$bannerdir = 'banners/';
for ($i=2; $i=4; $i++)
{
$result = dbquery("SELECT * FROM banners WHERE bannerloc='$i' and active='0' ORDER BY rand() LIMIT 1");
$row = mysql_fetch_array($result);
$bannerloc = stripslashes($row['bannerloc']);
if ($row['usealtpath'] == 0)
{
$bannerpath = htmlspecialchars(stripslashes($row['bannerpath']));
}
else
{
$bannerpath = htmlspecialchars(stripslashes($row['alternatepath']));
}
$bannerpath = $bannerdir. $bannerpath;
$linkurl = $url. stripslashes($row['bannerlink']);
switch ($bannerloc)
{
case "2":
$navban1= $bannerpath;
$navlink1= $linkurl;
break;
case "3":
$navban2= $bannerpath;
$navlink2= $linkurl;
break;
case "4":
$navban3= $bannerpath;
$navlink3= $linkurl;
break;
}// End Switch
//$id=$row['bannerid'];
//$result2=dbquery("UPDATE banners SET impressused=(impressused + 1), impresshist=(impresshist + 1) WHERE bannerid='$id'");
free($result);
}// End If
For the record the query does not fail. (dbquery is a function which I know works)
