title: Using PHP to declare a page url
body: <p>I am working on a project which allows me to create a customer database. I have made an Create.php and Delete.php but am having issues with the basic structure for an Edit page.</p>
  
  <p>My initial idea is to create a populated drop down box (Which I can do) which on click will take the user to domain.com/Customer.php?Customer_name="JohnD"</p>
  
  <p>I am having a few issues with regards to this as it is doing 2 things. </p>
  
  <ol>
  <li>It is printing out ALL of the data in my table into the echo.</li>
  <li>It isn't taking the values from the URL, However I know that I have missed something but am unsure of what I need to search for.</li>
  </ol>
  
  <p>Here is my snippet so far:</p>
  
  <pre><code>               &lt;h2&gt;
                  &lt;?Php
                  $sql="SELECT id,customer_name FROM Customers";
                  $result =mysql_query($sql);
                  while ($data=mysql_fetch_assoc($result)){
                  ?&gt;
                  &lt;?Php echo $data['customer_name']; } ?&gt;
                  &lt;/h2&gt;
  </code></pre>
  
  <p>As of yet I am getting this in the header:</p>
  
  <p>John Doe Jimmy Timmy Test</p>
  
  <p>These are all the values inside my rows for the table Customers.</p>
  
  <p>Sorry if the question seems all over the place. I will correct if it is not easy to understand.</p>
  
  <p>Thanks in advance</p>