<!-- DisplayRecList.php -->
<!-- Displays master list of recipes -->
<CENTER>
<H2>Recipe Master List</H2>
<?php
        $host = 'localhost';
        $user = 'vgmiller';
        $passwd = 'cs480';
        $database = 'vgmiller';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "select * from RECIPES";
        mysql_select_db($database);
        $result_id = mysql_query($query, $connect);
        if($result_id)
        {
                print '<table border=1>';
			print '<TH> RECIPE NAME <TH> COOKTIME(min) <TH> VEGAN <TH> VEGETARIAN <TH> GLUTEN-FREE  <TH> ING1 <TH> ING2 <TH> ING3 <TH> ING4 <TH> ING5 <TH> ING6 <TH> ING7 <TH> ING8 <TH> ING9 <TH> ING10';
                while($row = mysql_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
				print "<TD><CENTER> $field </CENTER></TD>";
                        print '</TR>';
                }
                print '</table>';
        }
        else
                print "Fail.<p>";
        mysql_close($connect);
?>
<P>
<FORM>
<A HREF="OnlineRecipeHome.html"><INPUT type="button" value="Recipe Home"></A>
</FORM>
</CENTER>