<?php require_once('../Connections/globalandes.php'); ?>
<?php require_once('../Connections/globalandes.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_globalandes, $globalandes);
$query_cat = "SELECT * FROM Catagory";
$cat = mysql_query($query_cat, $globalandes) or die(mysql_error());
$row_cat = mysql_fetch_assoc($cat);
$totalRows_cat = mysql_num_rows($cat);

$colname_product = "-1";
if (isset($_GET['product_id'])) {
  $colname_product = $_GET['product_id'];
}
mysql_select_db($database_globalandes, $globalandes);
$query_product = sprintf("SELECT * FROM product WHERE product_id = %s", GetSQLValueString($colname_product, "int"));
$product = mysql_query($query_product, $globalandes) or die(mysql_error());
$row_product = mysql_fetch_assoc($product);
$totalRows_product = mysql_num_rows($product);

$colname_image = "-1";
if (isset($_GET['product_id'])) {
  $colname_image = $_GET['product_id'];
}
mysql_select_db($database_globalandes, $globalandes);
$query_image = sprintf("SELECT * FROM product_image WHERE product_id = %s", GetSQLValueString($colname_image, "int"));
$image = mysql_query($query_image, $globalandes) or die(mysql_error());
$row_image = mysql_fetch_assoc($image);
$totalRows_image = mysql_num_rows($image);

$colname_product_image_id = "-1";
if (isset($_SESSION['product_id'])) {
  $colname_product_image_id = $_SESSION['product_id'];
}
mysql_select_db($database_globalandes, $globalandes);
$query_product_image_id = sprintf("SELECT image FROM product WHERE product_id = %s", GetSQLValueString($colname_product_image_id, "int"));
$product_image_id = mysql_query($query_product_image_id, $globalandes) or die(mysql_error());
$row_product_image_id = mysql_fetch_assoc($product_image_id);
$totalRows_product_image_id = mysql_num_rows($product_image_id);

$colname_name = "-1";
if (isset($_GET['product_id'])) {
  $colname_name = $_GET['product_id'];
}
mysql_select_db($database_globalandes, $globalandes);
$query_name = sprintf("SELECT product_id, cat_id, image, com_name_c FROM product WHERE product_id = %s", GetSQLValueString($colname_name, "int"));
$name = mysql_query($query_name, $globalandes) or die(mysql_error());
$row_name = mysql_fetch_assoc($name);
$totalRows_name = mysql_num_rows($name);

mysql_select_db($database_globalandes, $globalandes);
$query_cat01 = "SELECT * FROM Catagory WHERE Catagory.cat_id=1";
$cat01 = mysql_query($query_cat01, $globalandes) or die(mysql_error());
$row_cat01 = mysql_fetch_assoc($cat01);
$totalRows_cat01 = mysql_num_rows($cat01);

mysql_select_db($database_globalandes, $globalandes);
$query_cat02 = "SELECT Catagory.cat_name FROM Catagory WHERE Catagory.cat_id=2";
$cat02 = mysql_query($query_cat02, $globalandes) or die(mysql_error());
$row_cat02 = mysql_fetch_assoc($cat02);
$totalRows_cat02 = mysql_num_rows($cat02);

mysql_select_db($database_globalandes, $globalandes);
$query_cat03 = "SELECT Catagory.cat_name FROM Catagory WHERE Catagory.cat_id=3";
$cat03 = mysql_query($query_cat03, $globalandes) or die(mysql_error());
$row_cat03 = mysql_fetch_assoc($cat03);
$totalRows_cat03 = mysql_num_rows($cat03);

mysql_select_db($database_globalandes, $globalandes);
$query_drop01 = "SELECT product_id, com_name, cat_id FROM product WHERE cat_id = 1 ORDER BY com_name ASC";
$drop01 = mysql_query($query_drop01, $globalandes) or die(mysql_error());
$row_drop01 = mysql_fetch_assoc($drop01);
$totalRows_drop01 = mysql_num_rows($drop01);

mysql_select_db($database_globalandes, $globalandes);
$query_drop02 = "SELECT product_id, com_name, cat_id FROM product WHERE cat_id = 2 ORDER BY com_name ASC";
$drop02 = mysql_query($query_drop02, $globalandes) or die(mysql_error());
$row_drop02 = mysql_fetch_assoc($drop02);
$totalRows_drop02 = mysql_num_rows($drop02);

mysql_select_db($database_globalandes, $globalandes);
$query_drop03 = "SELECT product_id, com_name, cat_id, image FROM product WHERE cat_id = 3 ORDER BY com_name ASC";
$drop03 = mysql_query($query_drop03, $globalandes) or die(mysql_error());
$row_drop03 = mysql_fetch_assoc($drop03);
$totalRows_drop03 = mysql_num_rows($drop03);
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><!-- InstanceBegin template="/Templates/wine_detail_c.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>特鮮環球有限公司</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
<!--
#apDiv1 {
	position:absolute;
	left:55px;
	top:254px;
	width:421px;
	height:313px;
	z-index:1;
}
-->
</style>
<link href="ga_css_text.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<style type="text/css">
<!--
body {
	background-image: url(images/blue_gradient.jpg);
	background-repeat: no-repeat;
}
-->
</style>

<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {
	color: #FFFFFF;
	font-weight: bold;
	font-family: Arial, Helvetica, sans-serif;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>

</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/product_05.jpg','images/product_06_over.jpg','images/product_07_over.jpg')">
<!-- ImageReady Slices (home.ai) -->
<table border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="160"><table id="Table_01" height="160" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="538" rowspan="4" align="left" valign="top"><img src="images/content_logo_c.jpg" width="538" height="160"></td>
        <td width="281" height="79" align="left" valign="top"><img src="images/product_03.jpg" width="280" height="79"></td>
      </tr>
      <tr>
        <td height="25" align="left" valign="top"><a href="contact_c.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/content_contact_c_over.jpg',1)"><img src="images/content_contact_c.jpg" name="Image3" width="280" height="25" border="0"></a></td>
      </tr>
      <tr>
        <td height="25" align="left" valign="top"><a href="product_c.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','images/content_product_c_over.jpg',1)"><img src="images/content_product_c.jpg" name="Image6" width="280" height="25" border="0"></a></td>
      </tr>
      <tr>
        <td height="32" align="left" valign="top"><a href="index_c.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image5','','images/content_home_over_c.jpg',1)"><img src="images/content_home_c.jpg" name="Image5" width="281" height="32" border="0"></a></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td align="left" valign="top">
    
<table width="110%" border="0" align="left" cellpadding="0" cellspacing="0" background="images/blue_gradient.jpg" height="105%">
  <tr>
    <td width="214" align="left" valign="top"><table border="0" cellpadding="0" cellspacing="0">
      <tr background="images/blue_gradient.jpg">
        <td align="left" valign="top"><img src="images/content_product_name_c.jpg" width="214" height="59"></td>
      </tr>
      <tr background="images/blue_gradient.jpg">
        <td align="left" valign="top"><table border="0" cellspacing="0" cellpadding="0" background="transparent">
          <tr>
            <td><img src="images/spacer.gif" alt="blank space" width="30" height="10"></td>
            <td class="Product_cat">魚類</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><form name="form" id="form">
              <select name="fish" class="product_name" id="fish" onChange="MM_jumpMenu('parent',this,0)">
                <option value="#" selected>請選擇</option>
                <option value="ChileanSeaBass_c.html">智利白鱈魚</option>
                <option value="GiantSquid_c.html">大墨魚</option>
                <option value="Salmon_c.html">三文魚</option>
                <option value="SouthernHake_c.html">無鬚鱈魚</option>
                <option value="SwordFish_c.html">劍魚</option>
              </select>
            </form></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td class="Product_cat">海產</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><form name="form2" id="form2">
              <select name="seafood" class="product_name" id="seafood" onChange="MM_jumpMenu('parent',this,0)">
                <option value="#" selected>請選擇</option>
                <option value="BlueMussel_c.html">藍青口</option>
                <option value="Kingcrab_c.html">智利皇帝蟹</option>
                <option value="SeaUrchin_c.html">海膽</option>
                <option value="SeaScallop_c.html">帶子</option>
                <option value="RedAbalone_c.html">鮑魚</option>
              </select>
            </form></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td class="Product_cat">酒類</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><form name="form3" id="form3">
              <select name="wine" class="product_name" id="wine" onChange="MM_jumpMenu('parent',this,0)">
                <option value="#" selected>請選擇</option>
                <option value="Cabernet_c.html">Cabernet Sauvignon </option>
                <option value="Carmenere_c.html">Carmenere </option>
                <option value="Merlot_c.html">Merlot </option>
                <option value="Rose_c.html">Rosé - Cabernet Sauvignon</option>
                <option value="Sauvignon_c.html">Sauvignon Blanc </option>
              </select>
            </form></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><span class="Product_cat">新鮮生果</span></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><form name="form4" id="form4">
              <select name="Fresh" class="product_name" id="Fresh" onChange="MM_jumpMenu('parent',this,0)">
                <option value="#" selected>請選擇</option>
                <option value="Cherries_c.html">Cherries</option>
                <option value="Grapes_c.html">Grapes</option>
                <option value="Apples_c.html">Apples</option>
                <option value="Kiwifruit_c.html">Kiwifruit</option>
              </select>
            </form></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><span class="Product_cat">冷凍生果</span></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><form name="form1" method="post" action="">
              <select name="Frozen" class="product_name" id="Frozen" onChange="MM_jumpMenu('parent',this,0)">
                <option value="#" selected>請選擇</option>
                <option value="Raspberries_c.html">Raspberries</option>
                <option value="Blackberries_c.html">Blackberries</option>
                <option value="Strawberries_c.html">Strawberries</option>
                <option value="Blueberries_c.html">Blueberries</option>
                <option value="Grapesiqf_c.html">Grapes</option>
                <option value="Kiwis_c.html">Kiwis</option>
              </select>
            </form></td>
          </tr>
        </table>          <p>&nbsp;</p></td>
      </tr>
    </table></td>
    <td width="586" valign="top"><table border="0" cellpadding="0" cellspacing="5" >
      <tr>
        <td width="423" height="22" valign="top"><table border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            </tr>
          <tr>
            <td><table border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="47"><img src="images/spacer.gif" alt="image" width="10" height="10"></td>
                <td valign="top"><table border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td><img src="images/spacer.gif" width="5" height="5"></td>
                  </tr>
                  <tr>
                    <td><!-- InstanceBeginEditable name="photo" --><img src="images/product/Wine_Terrandes.jpg" width="88" height="277"><!-- InstanceEndEditable --><br></td>
                  </tr>
                  </table></td>
                </tr>
              </table></td>
            <td>&nbsp;</td>
            <td valign="top"><table width="322" border="0" cellpadding="0" cellspacing="3">
              
              <tr >
                <td width="313" height="22" bgcolor="#0099CC"><div align="center" class="style1"><!-- InstanceBeginEditable name="EditRegion9" -->Cabernet Sauvignon<!-- InstanceEndEditable --></div></td>
                </tr>
              <tr class="product_name">
                <td valign="top" class="product_name"><!-- InstanceBeginEditable name="EditRegion2" -->On the nose, red fruits, blueberries, plums and the soft presence of  floral aromas. On the palate it is tasty, soft and with an agreeable  finish. It is the perfect accompaniment for red meats and cheeses.<!-- InstanceEndEditable --></td>
              </tr>
              </table></td>
            </tr>
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            </tr>
          </table></td>
      </tr>
      </table></td>
  </tr>
</table>

    </td>
  </tr>
</table>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($cat);

mysql_free_result($product);

mysql_free_result($image);

mysql_free_result($product_image_id);

mysql_free_result($name);

mysql_free_result($cat01);

mysql_free_result($cat02);

mysql_free_result($cat03);

mysql_free_result($drop01);

mysql_free_result($drop02);

mysql_free_result($drop03);
?>