title: How to retrieve and display the same column Name from two tables in mysql php
body: <p>I'm trying to display data from two tables with the same column name by LEFT join keyword. How will it be possible to display data from the same column name in PHP?</p>
  
  <p>Retrieve from database in MySQL:</p>
  
  <pre><code>SELECT * FROM `photo` as A LEFT JOIN `users` B ON (A.photo = B.users)
  </code></pre>
  
  <p>The PHP code to display below:</p>
  
  <pre><code>for($i = 0; $i &lt; count($data); $i++){
     $date_added = $data[$i]['date_added']; 
     $date_added_2 = $data[$i]['date_added']; 
  </code></pre>