title: Picking up one record from MYSQL based on two tables
body: <p>I have two tables:</p>
  
  <p><strong>order</strong> with row <code>ID</code> and <code>ID_CLIENT</code></p>
  
  <p>and</p>
  
  <p><strong>user</strong> with row <code>ID</code>, <code>FIRSTNAME</code>, <code>SURNAME</code>, <code>PHONE</code> etc.</p>
  
  <p><strong>My problem is:</strong></p>
  
  <p>I want to see <code>order details</code> like <code>names, phone number</code> on page to exactly client <code>id</code> of order I'm looking at.</p>
  
  <p><strong>Tried this:</strong> </p>
  
  <pre><code>SELECT name FROM client,order WHERE order.id_client=client.id
  </code></pre>
  
  <p>but it came up with more than one name that should came with.</p>