title: PHP site URL ID please Help!
body: <p>Please could someone help im building my first website that pulls info from a MySQL table, so far ive successfully managed to connect to the database and pull the information i need.</p>
  
  <p>my website is set up to display a single record from the table, which it is doing however i need some way of changing the URL for each record, so i can link pages to specific records. i have seen on websites like facebook everyones profile ends with a unique number. e.g. <a href="http://www.facebook.com/profile.php?id=793636552" rel="nofollow">http://www.facebook.com/profile.php?id=793636552</a></p>
  
  <p>Id like to base my ID on the primary key on my table e.g. location_id</p>
  
  <p>ive included my php code so far, </p>
  
  <pre><code>&lt;?php
  require "connect.php";
  $query =  "select * from location limit 1";
  $result = @mysql_query($query, $connection) 
  or die ("Unable to perform query&lt;br&gt;$query");
  ?&gt;
  
  &lt;?php
  while($row= mysql_fetch_array($result))
  {
  ?&gt;
  
  &lt;?php echo $row['image'] ?&gt;
  
  &lt;?php
  }
  ?&gt;
  </code></pre>
  
  <p>Thanks</p>