mysql print data to display to html
<p>i've got a basic php script that's connects to mysql and print data but i'm having issues making it print via html the html i have atm this is only part of the html only the important part.
Sorry i have to type lots of crap so you can see this code because stackoverflow is such an amazing website, It helps lots and lots of people</p>

<pre><code>&lt;?php
$servername = "localhost";
$username = "root";
$password = "toor";
$dbname = "a3wasteland";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn-&gt;connect_error) {
    die("Connection failed: " . $conn-&gt;connect_error);
} 

$sql = "SELECT UID, BattlEyeGUID, CreationDate, Name, BankMoney FROM PlayerInfo";
$result = $conn-&gt;query($sql);

?&gt;
&lt;div class='cWidgetContainer ipsHide' data-controller='core.front.widgets.area' data-role='widgetReceiver' data-orientation='horizontal' data-widgetArea='header'&gt;
    &lt;ul class='ipsList_reset'&gt;

    &lt;/ul&gt;
  &lt;/div&gt;


&lt;div id="elCmsPageWrap" data-pageid="2"&gt;

&lt;div&gt;
  &lt;div class='ipsGrid ipsGrid_collapsePhone'&gt;
    &lt;div class='ipsGrid_span6'&gt;



  &lt;div class='cWidgetContainer ipsHide' data-controller='core.front.widgets.area' data-role='widgetReceiver' data-orientation='horizontal' data-widgetArea='col1'&gt;
    &lt;ul class='ipsList_reset'&gt;

    &lt;/ul&gt;
  &lt;/div&gt;

    &lt;/div&gt;
    &lt;div class='ipsGrid_span6'&gt;



  &lt;div class='cWidgetContainer ipsHide' data-controller='core.front.widgets.area' data-role='widgetReceiver' data-orientation='horizontal' data-widgetArea='col2'&gt;
    &lt;ul class='ipsList_reset'&gt;

    &lt;/ul&gt;
  &lt;/div&gt;

    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;



  &lt;div class='cWidgetContainer ' data-controller='core.front.widgets.area' data-role='widgetReceiver' data-orientation='horizontal' data-widgetArea='footer'&gt;
    &lt;ul class='ipsList_reset'&gt;


          &lt;li class='ipsWidget ipsWidget_horizontal ipsBox' data-blockID='plugin_20_sodPhpWidget_paxe9xcu5' data-blockConfig="true" data-blockTitle="PHP Code" data-controller='core.front.widgets.block'&gt;

&lt;div class='ipsWidget_inner '&gt;


    &lt;p class='ipsType_reset ipsType_medium ipsType_light'&gt;  
  &lt;style&gt;
  .specialType_center th {
    text-align: center; 
  }
  &lt;/style&gt;
&lt;/style&gt;
  &lt;h2 class="ipsType_sectionTitle ipsType_reset cForumTitle ipsResponsive_hideTablet ipsResponsive_hidePhone &lt;center&gt; "&gt;Banned Users&lt;/h2&gt;&lt;/center&gt;
    &lt;table class="ipsTable ipsTable_responsive ipsTable_zebra ipsBox ipsType_center specialType_center ipsResponsive_hideTablet ipsResponsive_hidePhone"&gt;
      &lt;thead&gt; 
   &lt;tr&gt;
      &lt;th&gt;UID&lt;/th&gt;
      &lt;th&gt;BattlEyeGUID&lt;/th&gt;
      &lt;th&gt;CreationDate&lt;/th&gt;
      &lt;th&gt;Name&lt;/th&gt;
      &lt;th&gt;BankMoney&lt;/th&gt;
    &lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;?php
/* Other code */
if ($result-&gt;num_rows &gt; 0) {
    while($row = $result-&gt;fetch_assoc()) {
?&gt;
        &lt;td&gt;&lt;span class="ipsType_negative"&gt;&lt;?=$row["UID"]?&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
        &lt;td&gt;&lt;span class="ipsType_negative"&gt;&lt;?=$row["BattlEyeGUID"]?&gt;&lt;/span&gt;&lt;/td&gt;
        &lt;td&gt;&lt;span class="ipsType_negative"&gt;&lt;?=$row["CreationDate"]?&gt;&lt;/span&gt;&lt;/td&gt;
        &lt;td&gt;&lt;span class="ipsType_negative"&gt;&lt;?=$row["Name"]?&gt;&lt;/span&gt;&lt;/td&gt;
        &lt;td&gt;&lt;span class="ipsType_negative"&gt;&lt;?=$row["BankMoney"]?&gt;&lt;/span&gt;&lt;/td&gt;
&lt;?php } 
} else { ?&gt;
    &lt;td colspan="5"&gt;0 results&lt;/td&gt;
&lt;?php } ?&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
    &lt;/table&gt;
  &lt;p class='ipsType_right ipsType_light ipsType_small ipsResponsive_hideTablet ipsResponsive_hidePhone' style='margin-right: 10px;'&gt;Last Update: 15.08.2016, 10:41 &lt;/p&gt;
&lt;/p&gt;

&lt;/div&gt;&lt;/li&gt;

&lt;/ul&gt;
  &lt;/div&gt;
</code></pre>