I have a php/mysql project and I am currently trying to display a table into an html table through PHP how ever Only the headers are getting returned not the actual table data, here is my query plus html table
<?php
$result = mysql_query("SELECT * FROM store");
echo"<table border = '1'>
<tr>
<th>Phone</th>
<th>Email</th>
<th>Address</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['phone'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td>" . $row['address']. "</td>";
echo "</tr>";
}
echo "</table>"
?>
any ideas as to why the table data may not be displaying?
Cheers!