[SOLVED] Parse error in PHPredirect - Cannot figure it out

[rlb1]

Please help me with this.  This redirect is not working.  Thanks!!!

 

 

 

 

 

<?

 

# GRAB THE VARIABLES FROM THE URL

$id = $_GET['idurl'];

$name = $_GET['name'];

 

 

 

 

 

// Otherwise we connect to our Database

mysql_connect("*******", "*******", "*******") or die(mysql_error());

mysql_select_db("champion_merchants") or die(mysql_error());

 

 

 

// Retrieve all the data from the "example" table

$result = mysql_query("SELECT * FROM zzounds WHERE id='$idurl'")

or die(mysql_error());

 

// store the record of the "example" table into $row

$row = mysql_fetch_array( $result );

 

 

 

// Trying to redirect to URL - I have tried

"{$row['Manufacturer']}"

{$row['URL_Product']}

  .$row['URL_Product']

 

 

header( 'Location: {$row['URL_Product']}' ) ;  // Need help here

 

 

echo "  ".$row['URL_Product'];  //This works great!!

 

?>

 

 

 

[trq]

echo "  ".$row['URL_Product'];  //This works great!!

 

And looks like?

[PHP_PhREEEk]

$redirect = $row['URL_Product'];
header ('Location: $redirect');

 

PhREEEk

[trq]

Actually, thanks to freaks post (he makes the same mistake) I just reliased your issue.

 

Variables are not interpolated within single quotes. Use....

 

header("Location: {$row['URL_Product']}");

[rlb1]

I am getting an error with both reccomendations...  How do I fix?

 

Warning: Cannot modify header information - headers already sent by (output started at /home/champion/public_html/directforless/page.php:2) in /home/champion/public_html/directforless/page.php on line 29

 

 

 

 

 

<?

 

# GRAB THE VARIABLES FROM THE URL

$id = $_GET['idurl'];

$name = $_GET['name'];

 

 

 

 

 

// Otherwise we connect to our Database

mysql_connect("*********", "*********", "*********") or die(mysql_error());

mysql_select_db("champion_merchants") or die(mysql_error());

 

 

 

// Retrieve all the data from the "example" table

$result = mysql_query("SELECT * FROM zzounds WHERE id='$idurl'")

or die(mysql_error());

 

// store the record of the "example" table into $row

$row = mysql_fetch_array( $result );

 

 

 

 

$redirect = $row['URL_Product'];

header ('Location: $redirect');            //  ERROR HERE ON LINE 29

[High_-_Tek]

You need to replace the single quotes on the header() line with double quotes.