title: Issue with using php and sql to add data to datables
body: <p>So I'm trying to use php and mysql to put data in my datatables on my website. I wrote some code at the top of my file to confirm that I am accessing my database correctly. The table is displayed correctly when i manually entered some data, but with my php code, the table says "No data available in table". Any thoughts on whats wrong with my php?</p>
  
  <pre><code>    $q = "SELECT tickets.ticket_id, tickets.section, tickets.row, tickets.price, users.first_name as first_name, users.last_name as last_name 
            FROM tickets 
            LEFT JOIN users 
            ON tickets.seller_id = users.umid
            Where(tickets.game_id = '$g')";
  
      $r = @mysqli_query ($dbc, $q);
  
  
  
       &lt;table id="example" class="display" cellspacing="0" width="100%"&gt;
       &lt;thead&gt;
          &lt;tr&gt;
             &lt;th&gt;Section&lt;/th&gt;
             &lt;th&gt;Row&lt;/th&gt;
             &lt;th&gt;Price&lt;/th&gt;
             &lt;th&gt;Seller&lt;/th&gt;
          &lt;/tr&gt;
       &lt;/thead&gt;
       &lt;tbody&gt;
  
          &lt;?php
             while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
  
             echo '
                &lt;tr&gt;
                   &lt;td&gt;'.$row["section"].'&lt;/td&gt;
                   &lt;td&gt;'.$row["row"].'&lt;/td&gt;
                   &lt;td&gt;'.$row["price"].'&lt;/td&gt;
                   &lt;td&gt;'.$row["first_name"]. " ". $row["last_name"]. '&lt;/td&gt;
                &lt;/tr&gt;
                ';
             }
          ?&gt;
  
       &lt;/tbody&gt;
    &lt;/table&gt;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/CqANY.jpg" rel="nofollow noreferrer">This is what the table looks like</a></p>
  
  <p><a href="http://michmarket.com/buy-ticket?id=F1" rel="nofollow noreferrer">Link to the webpage</a></p>