title: How to filter a table in SQL by a foreign key?
body: <p>I am making an website where bike repairs can be registered. It works, but now I am fine tuning. I have a MySQL database with a table called "Reparation", "Customer" and "bike"</p>
  
  <p>In bike, there is a unique ID with the model, brand, and so on. In Customer, there are the customerID, Customer name, adress, and so on. In Reparation I can select a customer and a bike, so they are related, that's good too :).</p>
  
  <p>When I select a customer in reparation, I want to see only his bikes. So, when the customer has two bikes, I want to select the customer and see the two bikes only (or the uniqueID'S from them).</p>
  
  <p>Now I select a customer, and I see all the bikes of all the customers. How do I do this, in phpMyAdmin or PHP? Both are good, but better phpMyAdmin if possible..</p>