Page not redirecting to correct url

[depraved]

Okay here's the piece of the code that I need to see if it's correct

$result = mysql_query ("SELECT url from track2 where id='$id'");

while ($row =@ mysql_fetch_array($result))
  {

   Header("Location: $row[url]");

  }

Is this correct?

I'm trying to redirect visitors from

domain.com/track.php?id=$id

to a url depending on what $id is. Still with me?😃

The problem is it won't send it to the specific page, it sends it to the main page.

ie. If I wanted to redirect visitors to

domain.com/test/test.html

it will instead send them to

domain.com

My table shows the correct url. My script just won't send them to it.

Thanks
Derek

[laserlight]

Maybe try something like:

<?php
$result = mysql_query("SELECT url from track2 where id='$id'");
if (mysql_num_rows($result) == 1)
{
	$row = mysql_fetch_array($result);
	echo $row['url']; //delete this later
	//header('Location: ' . $row['url']);
}
else
{
	exit("Error: id '$id' is not listed!");
}
?>

once the script writes the correct URL, delete the output statement then remove the comment from the header() and see how it goes.
It might be more prudent to use $_GET['id'] instead of $id, but that probably doesnt matter here.

[depraved]

WOOHOO! It worked!
Thanks alot

BTW What did you mean by using $_GET['id']?
I use it at the top of the script to get the variable out of the url if that's what you meant😃

Thanks Again
Derek

[laserlight]

well, then there should be no problem 🙂