Simple banner click and redirect help

[ldtiw]

Hey,

I have the following, and it subtracts the clicks. but i cant get it to refresh the page to go the banners url.

<?php 
$hostuser=''; 
$user='';    //user user for MySQL database 
$pass='';    //Password for database 
$dbase='';    //database user 

$connection = mysql_connect("$hostuser" , "$user" , "$pass") or die ("Can't connect to MySQL"); 
$db = mysql_select_db($dbase , $connection) or die ("Can't select database."); 

$result = mysql_query("SELECT b_id FROM ipals_banner WHERE b_id ='$banner_id' "); 
while ($row = mysql_fetch_array($result)) 
{ 
    extract($row); 

$qLink = "SELECT b_id, b_clicks, b_address FROM ipals_banner WHERE b_id ='$banner_id'"; 
$rsLink = mysql_query($qLink); 
$linkrow = mysql_fetch_array($rsLink); 
extract($linkrow); 

if ($b_clicks > 0)     
{ 
$query = 'UPDATE ipals_banner SET b_clicks = '.$b_clicks.'-1 WHERE b_id = '.$b_id.''; 

echo '<meta http-equiv="refresh" content"0;URL='.$b_address.'">';
} 
else 
{ 
    echo 'NO MORE CLICKS';

} 
    $rsInsert = mysql_query($qInsert); 


}                                                                                               

?>

Any help would be great!!

Thanks in advance!!

Danny

[Installer]

This is untested, so I'm not 100% sure, but I think this is closer to what you're trying to do:

$qLink = "SELECT b_id, b_clicks, b_address FROM ipals_banner WHERE b_id ='$banner_id'";  

$rsLink = mysql_query($qLink);  

while ($row = mysql_fetch_array($rsLink)) {  

    extract($row);  

    if ($b_clicks > 0) {  

        $query = 'UPDATE ipals_banner SET b_clicks = ' . $b_clicks . ' - 1 WHERE b_id = ' . $b_id;  

        $rsInsert = mysql_query($query);  

        echo '<meta http-equiv="refresh" content"0;URL=' . $b_address . '">'; 
    } else {  

        echo 'NO MORE CLICKS'; 
    }  

}