title: Changing date format when fetching data from MySQL in while loop
body: <p>Currently I fetch data from a MySQL database to a html table. The data is inserted via an html form first. </p>
  
  <p>One of the fields contains a date, which is entered in format <code>dd.mm.yyyy</code>.</p>
  
  <p>I already changed the date format in phpMyAdmin using the browser transformation feature. That works just fine. </p>
  
  <p>Unfortunately, the dates in my html table is still in default date format <code>mm-dd-yyyy</code>.</p>
  
  <p>My query currently looks like this: <code>$sql = "SELECT * FROM tablename ORDER BY ID DESC";</code></p>
  
  <p>My table has 6 columns, which should all be displayed in my html table. How do I have to change my query in order to get my desired date format in the html table?</p>
  
  <p>Hope you can help me. Thank you in advance.</p>
  
  <p>This is how my query and while loop looks like:</p>
  
  <pre><code>$sql = "SELECT * FROM tablename ORDER BY ID DESC";
  $query = mysqli_query($verbindung,$sql) or die(mysqli_error());
      echo '&lt;table&gt;';
      echo '&lt;thead&gt;';
      echo '&lt;tr&gt;';
      echo '&lt;th&gt;Number&lt;/th&gt;';
      echo '&lt;th&gt;Date&lt;/th&gt;';
      echo '&lt;th&gt;Time&lt;/th&gt;';
      echo '&lt;th&gt;Description&lt;/th&gt;';
      echo '&lt;th&gt;Place&lt;/th&gt;';
      echo '&lt;th&gt;Taken&lt;/th&gt;';
      echo '&lt;/tr&gt;';
          while($fetch = mysqli_fetch_assoc($query)) {
            echo '&lt;tr&gt;';
            echo '&lt;td&gt;' . $fetch['ID'] . '&lt;/td&gt;';
            echo '&lt;td&gt;' . $fetch['Date'] . '&lt;/td&gt;';
            echo '&lt;td&gt;' . $fetch['Time'] . '&lt;/td&gt;';
            echo '&lt;td&gt;' . $fetch['Description'] . '&lt;/td&gt;';
            echo '&lt;td&gt;' . $fetch['Place'] . '&lt;/td&gt;';
            echo '&lt;td&gt;' . $fetch['Taken'] . '&lt;/td&gt;';
            echo '&lt;/tr&gt;';
          }
      echo '&lt;/thead&gt;';
      echo '&lt;/table&gt;';
  </code></pre>