title: PHP Get Parent Info from MySQL Table
body: <p>I Have Two Tables, One of them Jobs and the Other Customers. Both Tables have Customer_ID, The Customer Table it is the primary and the Job has just a normal int field named Customer_ID. I Don't Want to use Foreign key because it doesn't display a value automatically. How can I get when the Row in the Job Table Has a Customer_ID # in the Customer Table have it Display the Customer_Name Field in the Customer Database?</p>
  
  <pre><code>// Data List from Table
  $jobs_a = array();
  $jobs_sql = $conn-&gt;query("SELECT * FROM `MyDB`.`Jobs`")
  while($jobs = $jobs_sql-&gt;fetch_array(MYSQLI_ASSOC)) {
          $customer_id = $jobs['Customer_ID'];
          $jobs_a[$customer_id] = $jobs;
  }
  </code></pre>