how do I use URIs with variables

[JiX]

Ok, this is what I want to do:

send a confirmation URI to a person who signed up at my site. that URI will have a variable called SID that is used to confirm the e-mail address. Then I want to use that variable in the page I send the person.

how do I do that? how do I set up and use a variable in the URI?

thanks, I hope you understood what I'm trying to do.

[planetsim]

1) Make sure you send your email as HTML or as most Mail Servers Parse URl's now you could just do it the easy way..

Anyway

http://www.servername.com?sid=$sid

send it in the email or whatever basically the same as you'd do it on the site.

[JiX]

that's what I've been trying to do, but it doesn't work:

here's some of the code:

i changed the SID to confirmid by the way, thought it was better name for the variable...

<?php

if (!$confirmid)
{
print("ERROR!!!");
}

$db = mysql_connect("localhost");
mysql_select_db("tempregs", $db);
$result = mysql_query("SELECT * FROM data WHERE id = '$confirmid'", $db);

$row = mysql_num_rows($result);

if ($row == 1)
{
print("Sorry, but you cannot sign up at the moment, for I am still beta-testing my services. Be patient\n");
}

mysql_close();

?>

then I use this link, for example:

http://localhost/confirm.php?confirmid=QfxucOhzpBtJLtvD

but nothing, that confirmid is in the mysql database, I've triple checked it but still it doesn't work like it's supposed to 😕

EDIT! I added the print("Error!!!"); function, and it always prints ERROR!!! no matter what. even though I copy an id value straight from my database and use the
http://localhost/confirm.php?confirmid=confirmidvalue
link, it still doesn't work... so the problem seems to be in the URI... 😕

[JiX]

Ok, I got it at last, I just had to use $_GET['confirmid'] instead of $confirmid :p that took me three hours to find