title: Php/Mysql Export data from two tables
body: <p>I need to export data from two tables Php/Mysql to Excel or CSV file. I try with Union All but I get data in one cell I need next format:</p>
  
  <pre><code>Name:   Age (from another table)
  Levan   22
  Dito    35
  Giorgi  46
  </code></pre>
  
  <p>I receive next:</p>
  
  <pre><code>Name:
  Levan   
  Dito    
  Giorgi
  22
  35
  46
  </code></pre>
  
  
  
  <pre><code>&lt;?php
      header("Content-type: text/csv; charset=UTF-8");
      header('Content-Disposition: attachment; filename=Export.csv');
  
      //connection
      $con = mysql_connect('localhost', 'user', 'pass');
      if(!$con) {
          echo "Error connection";
      }
  
      //select db
      $select_db = mysql_select_db('database', $con);
      if(!$select_db) {
          echo "Error to select database";
      }
  
      mysql_set_charset("utf8", $con);
  
      //Mysql query to get records from datanbase
      $user_query = mysql_query('SELECT Amount FROM Credit UNION ALL SELECT username FROM User');
  
      //While loop to fetch the records
      $contents = "Amount \t username\n";
      while($row = mysql_fetch_array($user_query)) {      
          $contents.=$row['Amount']."\t";
          $contents.=$row['username']."\n";       
      }
  
      $contents_final = chr(255).chr(254).mb_convert_encoding($contents, "UTF-16LE","UTF-8");
      print $contents_final;
  ?&gt;
  </code></pre>