title: Change output variables MySQL query
body: <p>If I do this kind of query: </p>
  
  <pre class="lang-php prettyprint-override"><code>&lt;?php
  SELECT * FROMloginwhereemail = 'something@something.com';
  $result = mysqli_query($connection, $query) or die("Query error");
  while ($row = mysqli_fetch_array($result)) {
      $id = $row['id'];
      $email = $row['email'];
      $first_name = $row['first_name'];
      //(......)
  }
  ?&gt;
  </code></pre>
  
  <p>is there a way that the MySQL result can be with different variable names?
  I mean:</p>
  
  <pre class="lang-php prettyprint-override"><code>SELECT (first_name as foo) FROM login where email = 'something@something.com';
  
  $first_name = $row['foo'];
  </code></pre>