Location: PHPKode > projects > ExPHPresso > exPHPresso-0.0.2/all_coffees.php
<?php include("config.php"); ?>

<?php include("header.inc.php"); ?>

<html>

<head>

<title><? print $site_name; ?></title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" href="main.css" type="text/css">

</head>

<body bgcolor="#FFFFFF" text="#000000" link="#CC6600" alink="#CC6600" vlink="#CC6600">

<table border="0" cellspacing="0" cellpadding="0" width="95%">

  <tr> 

    <td width="<? print $side_nav_table; ?>" valign="top">&nbsp; </td>

    <td rowspan="2" width="10"><img src="images/spacer.gif" width="14" height="23"></td>

    <td><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF6600">COFFEE 

      RECIPES - <a href="print_allrecipes.php">(print view)</a></font></b></td>

  </tr>

  <tr> 

    <td width="<? print $side_nav_table; ?>" valign="top" height="28"> 

      <?php include("left.inc.php"); ?>

    </td>

    <td width="" height="28"> 

      <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="#000000">

        <tr> 

          <td height="31"> 

            <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FF9900" height="1">

              <tr> 

                <td><img src="fake_spacer.gif" width="1" height="1"></td>

              </tr>

            </table>

            <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="e0e0e0">

              <tr> 

                <td class="tbl_hdr" align="center" colspan="2" > 

                  <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>COFFEE 

                    CLASSICS</b></font></div>

                </td>

                <td width="1%" background="images/line.gif" rowspan="2"><img src="images/spacer.gif" width="8" height="8"></td>

                <td class="tbl_hdr" align="center" colspan="2"> 

                  <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>COFFEE 

                    SPECIALTIES</b></font></div>

                </td>

                <td width="1%" background="images/line.gif" rowspan="2"> 

                  <h5><img src="images/spacer.gif" width="8" height="8"></h5>

                </td>

                <td class="tbl_hdr" align="center" colspan="2"> 

                  <div align="center"><font size="2"><b><font face="Verdana, Arial, Helvetica, sans-serif">	

                    COFFEE BY COUNTRIES</font></b></font></div>

                </td>

              </tr>

              <tr> 

                <td class="tbl_info" width="1%"><img src="images/spacer.gif" width="8" height="8"> 

                </td>

                <td class="tbl_info" width="29%" valign="top"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 

                  <?

		$result=mysql_query("SELECT * FROM coffees WHERE coffee_type LIKE 'classics';");

		while($row=MySQL_fetch_array($result))

		{

		$id=$row["id"];

		$coffee_type=$row["coffee_type"];

		$coffee_name=$row["coffee_name"];

		$coffee_details=$row["coffee_details"];

		print "<a href=\"classics.php?id=$id\">&#149;$coffee_name<br></a>"; 

		}

		?>

                  </font> </td>

                <td class="tbl_info" width="1%"><img src="images/spacer.gif" width="8" height="8"> 

                </td>

                <td class="tbl_info" width="33%" valign="top"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 

                  <?

		$result=mysql_query("SELECT * FROM coffees WHERE coffee_type LIKE 'specialty';");

		while($row=MySQL_fetch_array($result))

		{

		$id=$row["id"];

		$coffee_type=$row["coffee_type"];

		$coffee_name=$row["coffee_name"];

		$coffee_details=$row["coffee_details"];

		print "<a href=\"classics.php?id=$id\">&#149;$coffee_name<br></a>"; 

		}

		?>

                  </font> </td>

                <td class="tbl_info" width="1%"><img src="images/spacer.gif" width="8" height="8"> 

                </td>

                <td class="tbl_info" width="32%" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 

                  <?

		$result=mysql_query("SELECT * FROM coffees WHERE coffee_type LIKE 'country';");

		while($row=MySQL_fetch_array($result))

		{

		$id=$row["id"];

		$coffee_type=$row["coffee_type"];

		$coffee_name=$row["coffee_name"];

		$coffee_details=$row["coffee_details"];

		print "<a href=\"classics.php?id=$id\">&#149;$coffee_name<br></a>"; 

		}

		?>

                  </font> </td>

              </tr>

            </table>

          </td>

        </tr>

      </table>

    </td>

  </tr>

  <tr> 

    <td width="<? print $side_nav_table; ?>" valign="top" height="22">&nbsp;</td>

    <td rowspan="5" width="10">&nbsp;</td>

    <td width="" height="22"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF6600">COFFEE 

      FACTS - <a href="print_allcountryfacts.php">(print view)</a></font></b></td>

  </tr>

  <tr> 

    <td width="<? print $side_nav_table; ?>" valign="top" height="29">&nbsp;</td>

    <td width="" height="29"> 

      <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="#000000">

        <tr> 

          <td height="33"> 

            <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FF9900" height="1">

              <tr> 

                <td><img src="fake_spacer.gif" width="1" height="1"></td>

              </tr>

            </table>

            <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="e0e0e0">

              <tr> 

                <td class="tbl_hdr" align="center" colspan="2" > 

                  <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>COFFEE 

                    FACTS BY COUNTRY</b></font></div>

                </td>

              </tr>

              <tr> 

                <td class="tbl_info" width="0%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img src="images/spacer.gif" width="8" height="8"> 

                  </font> </td>

                <td class="tbl_info" width="100%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 

                  <?

		$result=mysql_query("SELECT id,coffee_name from types ORDER by coffee_name ASC LIMIT 0, 30 ;");

		while($row=MySQL_fetch_array($result))

		{

		$id=$row["id"];

		$coffee_name=$row["coffee_name"];

		print "<a href=\"facts_by_country.php?id=$id\">&#149;$coffee_name &nbsp;</a>"; 

		}

		?>

                  </font></td>

              </tr>

            </table>

          </td>

        </tr>

      </table>

    </td>

  </tr>

  <tr>

    <td width="<? print $side_nav_table; ?>" valign="top" height="29">&nbsp;</td>

    <td width="" height="29"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF6600">COFFEE 

      DEFINITIONS - <a href="print_alldefinitions.php">(print view)</a></font></b></td>

  </tr>

  <tr>

    <td width="<? print $side_nav_table; ?>" valign="top" height="29">&nbsp;</td>

    <td width="" height="29">

      <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="#000000">

        <tr> 

          <td height="33"> 

            <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FF9900" height="1">

              <tr> 

                <td><img src="fake_spacer.gif" width="1" height="1"></td>

              </tr>

            </table>

            <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="e0e0e0">

              <tr> 

                <td class="tbl_hdr" align="center" colspan="2" > 

                  <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>COFFEE 

                    DEFINITIONS</b></font></div>

                </td>

              </tr>

              <tr> 

                <td class="tbl_info" width="0%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><img src="images/spacer.gif" width="8" height="8"> 

                  </font> </td>

                <td class="tbl_info" width="100%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 

                  <?

		$result=mysql_query("SELECT id,def_name from definition ORDER by def_name ASC LIMIT 0, 30 ;");

		while($row=MySQL_fetch_array($result))

		{

		$id=$row["id"];

		$def_name=$row["def_name"];

		print "<a href=\"facts_by_definition.php?id=$id\">&#149;$def_name &nbsp;</a>"; 

		}

		?>

                  </font></td>

              </tr>

            </table>

          </td>

        </tr>

      </table>

    </td>

  </tr>

</table>

<br>

<?php include("footer.inc.php"); ?>

</body>

</html>
Return current item: ExPHPresso