title: Selecting multiple columns with the same name in MySQL
body: <p>I wanted to access two tables in mysql and want to use the fields in both tables. I used a innerjoin to match both tables, but wondering how to fetch the field in both tables, coz both tables are having same field name and different values.
  Here is my query...</p>
  
  <pre><code>$query1 = mysql_query("SELECT facilitator.FacID, facilitator.email, assigned.email FROM facilitator INNER JOIN assigned ON facilitator.FacID = assigned.FacID WHERE assigned.email = '$stuemail' AND facilitator.active = '1'") or die($query."&lt;br/&gt;&lt;br/&gt;".mysql_error());
              while($line1=mysql_fetch_array($query1,MYSQL_ASSOC)){
                  $faci= $line1['FacID'];
                  $facemail = $line1['email'];
                  $stumail2 = $line1['email'];
  .............code goes on.............. 
  </code></pre>
  
  <p>I want to fetch both emails field values but wondering how to do. I am sure what I have wrote for $stumail2 is wrong. Please help me. </p>