PHP Mysql Code Problem

[plittle]

Hello I am fairly new to PHP and mySql, and I have been working on a redirect system for a website I am making What I am trying to do is get the URL from the mySql database using a link from the page. Can someone help me to figure out the proper way of getting the header part working. The below (header("Location: $row["$id"]); ) doesn't work so I know its wrong. Thank you for any help or suggestions.

LINK CODE:

echo "<li><a href=\"./redirect.php?id=Track_1_intro&Album=$Album \">$Track_1</a></li>\n";

LINK IN NAV BAR: http://127.0.0.1/redirect.php?id=Track_1_intro&Album=Our%20Anchor%20Will%20Hold

REDIRECT CODE:

<?php

mysql_connect("localhost", "user", "password");
  @mysql_select_db("forms") or die( "Unable to connect to database");
  $id = mysql_real_escape_string($_GET['id']);
  $Album = mysql_real_escape_string($_GET['Album']);

$query = "SELECT * FROM music WHERE album='$Album' "; 

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());

echo $row["$id"]. " - ". $row['album'];

header("Location: $row["$id"]);

    exit;
mysql_close();

?>

[NogDog]

1. header() won't work if any output precedes it (e.g. echoes or any text/white-space not within <?php...?> tags).

2. Your quoting is a bit off:

   header("Location: $row["$id"]);
   // should be:
   header("Location: " . $row[$id]);
   // or:
   header("Location: {$row[$id]}");
   

3. Chances are you want to urlencode() it:

   header("Location: " . urlencode($row[$id]));
   

[benreisner]

If I understand your sample code your redirect code will be hit with:
ID=Track_1_intro
Album=Our Anchor Will Hold

You then do a select * from music and you look at the FIRST row.
What type of data does your select statement return? Does it actually have a field labelled 'Track_1_intro?

More commonly your statement would look like 'select url from music where id=$id and album=$album', and your location would be $row['url']. Its hard to say without knowing your field layout