Dynamic rediect - should be easy?

PHP
1

Is there a reason why this isn’t working?

<?

include "connect.inc.php";

$advert_id = $_GET['advert_id'];

$query = "SELECT advert_link, advert_click_count FROM advert WHERE advert_id = '$advert_id'";
$result = mysql_query($query);

while ($array = mysql_fetch_assoc($result)) {

$advert_link = $array['advert_link'];
$advert_click_count = $array['advert_click_count'] + 1;
mysql_query("UPDATE advert SET advert_click_count = '$advert_click_count'");

}

$redirect = "Location $advert_link";

//echo "$redirect";
header("Location $advert_link");
?>
2

You forgot the column after Location

Example


header('Location: http://www.sitepoint.com/');
3

Thanks