[RESOLVED] Header Redirect Issue

[scriderpsd]

I'm trying to create a dynamic header redirect based on a query string variable but I can't get the header function to accept a variable. My code looks like this...

<?php
$id=$_GET['id'];
include('db.php');
$conn = db_connect();
$query="select * from florists where florist_id=$id";
$result= mysql_query($query, $conn) or die('Error, this query failed');
$array=mysql_fetch_array($result);
$url=$array['aff_link_redirect'];
//echo $url;
header( 'Location: $url' ) ;
?>

$url is the url I want to redirect to. Any help is much appreciated. You can probably see what I'm trying ot do. If there's a better way, please let me know.

Thanks,

Scott

[laserlight]

How does it not work?

[scriderpsd]

laserlight wrote:

How does it not work?

When I try click the link I get an Object Not Found and URL looks like this...

http://localhost/flowers/$url

[laserlight]

Oh, that's because variables are not interpolated within single quoted strings. To make the variables be parsed, you need to use double quoted strings, or concatenation:

header( "Location: $url" ) ;
//or
header( 'Location: ' . $url ) ;

[scriderpsd]

Thank you very much!