[SOLVED] Newbie query - GET Command

[marco839]

Hiya,

 

I'm trying to use the idea of file.php?id=1 to grab a row and display it on the page. below is my script..

 

<?php
  $id = $_GET['id'];

  mysql_connect("LOCALHOST", "USERNAME", "PASSWORD");
  mysql_select_db("DATABASE") or die( "Unable to connect to database");
  $result = mysql_query("SELECT * FROM linkcount WHERE id='$id'");
  $row = mysql_fetch_array($result);
echo "Name: ".$row["name"];
echo "<br>Addres: ".$row["address"];
echo "<br>Postcode: ".$row["postcode"];
echo "<br>Telephone: ".$row["telephone"];
echo "<br>Website: ".$row["website"];
?>

 

I'm trying to have the system load from id1 the details (e.g. file.php?id=2 will load row #2.. 3 #3... etc)

But, it won't display and information - any ideas?

 

Thanks very much for any help,

 

Marco

[nathanmaxsonadil]

try changing

  $result = mysql_query("SELECT * FROM linkcount WHERE id='$id'");

to

  $result = mysql_query("SELECT * FROM linkcount WHERE id='{$id}'");

[marco839]

Thank you - that's great, i've been pulling hair out trying to work this out.

 

Query though, (As I want to learn more...), why do the {}'s need to be around the id bit?

[nathanmaxsonadil]

lol I'm not sure but you need it around a variable also it does'nt work inside ' ' quotes