I'm trying to pull my information from the database, which I've managed, and store it in a table. However I keep getting errors. Can anyone see the problem?
<?php
//Make connection to database
$connection = mysqli_connect('localhost', 'root', '', 'c3438525');
//Display heading
//run query to select all records from customer table
//store the result of the query in a variable called $result
//Use a while loop to iterate through your $result array and display
//each field wrapped in appropriate HTML table tags.
//include 'connection.php'
include 'products.css'
$query="SELECT * FROM products";
$results=mysqli_query($connection, $query);
while($row=mysqli_fetch_assoc($results)){
?>
<table class='display'>
<tr><td><?php echo "<img src=$rows[$product_image] height='200px' width='200px'>" ?></td></tr>
<tr>
<td><b><?php echo "$rows[$product_name]" ?></td>
<td><b><?php echo "Price: £ $rows[$price]" ?></td>
<td><b><?php echo "Picture: $rows[$product_image]" ?></td>
</tr>
</table>
<?php
}
?>