easy question here

[depraved]

I made a link tracking script and got everything to work so far except for one thing.

My script changes the tracked url to have
domain.com/track.php?id=$id.

The $id is the name given to the url they want to have tracked

My question is how do I get the url out of the table by using its $id?

Basically what I want is, the script will look into the table for $id, then look for the url that is in the same row as $id and give me back the url

Thanks
Derek

[leatherback]

Try something like:

$result = mysql_query ('select url from table where id=$id');

while $row =@ mysql_fetch_array($result)
  {
   echo $row[url];
  }

J.

[depraved]

THANKS

I got it to work using

$result = mysql_query ('select url from table where id=$id');

while ($row =@ mysql_fetch_array($result))
  {
   echo $row[url];
  }

I added () in the second line