<? echo $id?> and mysql

[Anon]

Thanks!!!!!

I want to put the info after the ? in the url (/test.php?id=2002) into line 11.

I know about <? echo $id?> (and I get the res. 2002 when I put <? echo $id?> as a line 0), but this isn't working when I put this into line 11.

1. <?php
2. $db_name = "myname";
3. $table_name = "redirects";
   4.
4. $cnx = mysql_connect("host", "myname", "pass")
5. or die("Couldn't connect.");
   7.
6. $db = mysql_select_db($db_name, $cnx)
7. or die("Couldn't select database.");
   10.
8. $id = 2002; //The id we want to get
   12.
9. $result = mysql_query("SELECT address,label from redirects 14. WHERE id=" . $id) or die("Error! " . $mysql_error($dblink));
10. list($myAddress,$myLabel) = mysql_fetch_row($result);
    16.
11. print "" . $myaddress . "" . $myLabel . "\n";
12. ?>

</pre>

What's the solution?

Thanks,

abcd

[Anon]

Just a simple mistake in your code:

14. WHERE id=$id") or die