Hello, I"m putting php into an html file, and my teacher gave us a template for uploading the table into the HTML. I have a table called gamies. Where do I need to make the change in the following code for it to dsiplay the following table:

$host = "localhost";

$user = "root";

$password = "";

$database = "test";

$query = "";

//OPEN CONNECTION TO THE DATABASE

$connection = mysqli_connect ($host, $user, $password, $database);

//RUN QUERY AGAINST TABLE AND FETCH RESULT

$result_set = mysqli_query($connection, $query);

//$result = mysqli_fetch_assoc($result_set);

//LOOP THROUGH RESULT SET AND PRINT DATA

//GET COUNT

$count = mysqli_num_rows ($result_set);

echo "There are " . $count . " rows
";

//USE FOR LOOP

for($i=0; $i

{

$result = mysqli_fetch_assoc($result_set);

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";

}

//CLOSE THE CONNECTION

mysqli_close ($connection);

?>

" . $result[''] . "	" . $result[''] . "	" . $result[''] . "	" . $result[''] . "

Product Name Cards Against Hue-Maat price 523.99 age range 18 Mad-Blab A game of trying 514.75 Ticket to Hide 12.50 you 12.50, Has your girlfriend150