<?php require_once('Connections/cntvivero.php'); ?>
<? 
error_reporting(E_ALL & ~E_NOTICE);
ob_start();
include("carrito.php");
$usercart = new Cart;
$np=1;
function GetRows($rows){
	$num=$rows / 3;
	$cad=strval($num);
	$pos=strpos($cad,".");
	if($pos === false){
		$find=true;
	}else{
		$find=false;
	}
	return $find;
}

?>
<?php
if(isset($cat)){
	$filtro="WHERE cantidad > 0 AND categoria LIKE '" . $cat . "' AND exclusivo LIKE 'NO' ORDER BY clave ASC";
	$categ=$cat;
}else{
	$filtro="WHERE cantidad > 0 AND exclusivo LIKE 'NO' ORDER BY clave ASC";
	$categ="Catalogo";
}
if(isset($promo)){
	$filtro="WHERE cantidad > 0 AND exclusivo LIKE 'NO' AND promo LIKE 'SI' ORDER BY clave ASC";
	$categ="Catalogo";

}


$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "frmcatalogo")) {
//echo "Buscar planta " . $HTTP_POST_VARS["nombre"];
	$filtro="WHERE producto LIKE '%" . $HTTP_POST_VARS["nombre"] . "%' AND exclusivo LIKE 'NO'";

//$updateGoTo = "mfghdfhgfh";
/*  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));*/
}

$maxRows_rscatalogo = 6;
$pageNum_rscatalogo = 0;
if (isset($HTTP_GET_VARS['pageNum_rscatalogo'])) {
  $pageNum_rscatalogo = $HTTP_GET_VARS['pageNum_rscatalogo'];
}
$startRow_rscatalogo = $pageNum_rscatalogo * $maxRows_rscatalogo;

mysql_select_db($database_cntvivero, $cntvivero);
$query_rscatalogo = "SELECT * FROM productos " . $filtro;
$query_limit_rscatalogo = sprintf("%s LIMIT %d, %d", $query_rscatalogo, $startRow_rscatalogo, $maxRows_rscatalogo);
$rscatalogo = mysql_query($query_limit_rscatalogo, $cntvivero) or die(mysql_error());
$row_rscatalogo = mysql_fetch_assoc($rscatalogo);

if (isset($HTTP_GET_VARS['totalRows_rscatalogo'])) {
  $totalRows_rscatalogo = $HTTP_GET_VARS['totalRows_rscatalogo'];
} else {
  $all_rscatalogo = mysql_query($query_rscatalogo);
  $totalRows_rscatalogo = mysql_num_rows($all_rscatalogo);
}
$totalPages_rscatalogo = ceil($totalRows_rscatalogo/$maxRows_rscatalogo)-1;

$maxRows_rscategorias = 6;;
$pageNum_rscategorias = 0;
if (isset($HTTP_GET_VARS['pageNum_rscategorias'])) {
  $pageNum_rscategorias = $HTTP_GET_VARS['pageNum_rscategorias'];
}
$startRow_rscategorias = $pageNum_rscategorias * $maxRows_rscategorias;

mysql_select_db($database_cntvivero, $cntvivero);
$query_rscategorias = "SELECT * FROM categorias ORDER BY id ASC";
$query_limit_rscategorias = sprintf("%s LIMIT %d, %d", $query_rscategorias, $startRow_rscategorias, $maxRows_rscategorias);
$rscategorias = mysql_query($query_limit_rscategorias, $cntvivero) or die(mysql_error());
$row_rscategorias = mysql_fetch_assoc($rscategorias);

if (isset($HTTP_GET_VARS['totalRows_rscategorias'])) {
  $totalRows_rscategorias = $HTTP_GET_VARS['totalRows_rscategorias'];
} else {
  $all_rscategorias = mysql_query($query_rscategorias);
  $totalRows_rscategorias = mysql_num_rows($all_rscategorias);
}
$totalPages_rscategorias = ceil($totalRows_rscategorias/$maxRows_rscategorias)-1;

$queryString_rscatalogo = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rscatalogo") == false && 
        stristr($param, "totalRows_rscatalogo") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rscatalogo = "&" . implode("&", $newParams);
  }
}
$queryString_rscatalogo = sprintf("&totalRows_rscatalogo=%d%s", $totalRows_rscatalogo, $queryString_rscatalogo);
?>
<html>
<head>
<title>PSI MEXICO [ Plant Source International M&eacute;xico ]</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.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_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_nbGroup(event, grpName) { //v6.0
  var i,img,nbArr,args=MM_nbGroup.arguments;
  if (event == "init" && args.length > 2) {
    if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
      img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
      if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
      nbArr[nbArr.length] = img;
      for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
        if (!img.MM_up) img.MM_up = img.src;
        img.src = img.MM_dn = args[i+1];
        nbArr[nbArr.length] = img;
    } }
  } else if (event == "over") {
    document.MM_nbOver = nbArr = new Array();
    for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
      nbArr[nbArr.length] = img;
    }
  } else if (event == "out" ) {
    for (i=0; i < document.MM_nbOver.length; i++) {
      img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
  } else if (event == "down") {
    nbArr = document[grpName];
    if (nbArr)
      for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
    document[grpName] = nbArr = new Array();
    for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
      nbArr[nbArr.length] = img;
  } }
}
//-->
</script>
<style type="text/css">
<!--
body {
	background-color: #a9dd86;
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>

<body onLoad="MM_preloadImages('principal/index_r4_c5_f3.jpg','principal/index_r4_c5_f2.jpg','principal/index_r4_c5_f4.jpg','principal/index_r6_c8_f3.jpg','principal/index_r6_c8_f2.jpg','principal/index_r6_c8_f4.jpg','principal/index_r8_c7_f3.jpg','principal/index_r8_c7_f2.jpg','principal/index_r8_c7_f4.jpg','principal/index_r10_c2_f3.jpg','principal/index_r10_c2_f2.jpg','principal/index_r10_c2_f4.jpg','principal/index_r12_c4_f3.jpg','principal/index_r12_c4_f2.jpg','principal/index_r12_c4_f4.jpg','principal/index_r16_c6_f3.jpg','principal/index_r16_c6_f2.jpg','principal/index_r16_c6_f4.jpg','principal/index_r18_c8_f3.jpg','principal/index_r18_c8_f2.jpg','principal/index_r18_c8_f4.jpg')">
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <!-- fwtable fwsrc="principal.png" fwbase="index.jpg" fwstyle="Dreamweaver" fwdocid = "1669989356" fwnested="0" -->
  <tr>
    <td><img src="principal/spacer.gif" width="31" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="6" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="12" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="19" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="12" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="8" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="23" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="61" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="8" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="57" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="313" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="42" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="145" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="63" height="1" border="0" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="9" align="center" valign="middle" background="principal/index_r1_c1.jpg"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="135" height="112">
      <param name="movie" value="maquesina.swf">
      <param name="quality" value="high">
	  <param name="wmode" value="transparent">
      <embed src="maquesina.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="135" height="112"></embed>
    </object></td>
    <td colspan="2"><img name="index_r1_c10" src="principal/index_r1_c10.jpg" width="370" height="180" border="0" id="index_r1_c10" alt="" /></td>
    <td colspan="3"><img name="index_r1_c12" src="principal/index_r1_c12.jpg" width="250" height="180" border="0" id="index_r1_c12" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="180" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="14"><img name="index_r2_c1" src="principal/index_r2_c1.jpg" width="800" height="18" border="0" id="index_r2_c1" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="18" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="10"><img name="index_r3_c1" src="principal/index_r3_c1.jpg" width="237" height="89" border="0" id="index_r3_c1" alt="" /></td>
    <td colspan="3" rowspan="17" align="left" valign="middle" background="principal/index_r3_c11.jpg"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="500" height="350">
      <param name="movie" value="vr.swf">
      <param name="quality" value="high">
	  <param name="wmode" value="transparent">
      <embed src="vr.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="500" height="350"></embed>
    </object></td>
    <td rowspan="17"><img name="index_r3_c14" src="principal/index_r3_c14.jpg" width="63" height="350" border="0" id="index_r3_c14" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="89" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="6" colspan="4"><img name="index_r4_c1" src="principal/index_r4_c1.jpg" width="68" height="70" border="0" id="index_r4_c1" alt="" /></td>
    <td colspan="4"><a href="quienes.htm" target="_top" onClick="MM_nbGroup('down','navbar1','index_r4_c5','principal/index_r4_c5_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r4_c5','principal/index_r4_c5_f2.jpg','principal/index_r4_c5_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r4_c5" src="principal/index_r4_c5.jpg" width="104" height="11" border="0" id="index_r4_c5" alt="" /></a></td>
    <td rowspan="16" colspan="2"><img name="index_r4_c9" src="principal/index_r4_c9.jpg" width="65" height="261" border="0" id="index_r4_c9" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="11" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="4"><img name="index_r5_c5" src="principal/index_r5_c5.jpg" width="104" height="12" border="0" id="index_r5_c5" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="12" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="2" colspan="3"><img name="index_r6_c5" src="principal/index_r6_c5.jpg" width="43" height="24" border="0" id="index_r6_c5" alt="" /></td>
    <td><a href="catalogo.php" target="_top" onClick="MM_nbGroup('down','navbar1','index_r6_c8','principal/index_r6_c8_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r6_c8','principal/index_r6_c8_f2.jpg','principal/index_r6_c8_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r6_c8" src="principal/index_r6_c8.jpg" width="61" height="11" border="0" id="index_r6_c8" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="11" border="0" alt="" /></td>
  </tr>
  <tr>
    <td><img name="index_r7_c8" src="principal/index_r7_c8.jpg" width="61" height="13" border="0" id="index_r7_c8" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="13" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="2" colspan="2"><img name="index_r8_c5" src="principal/index_r8_c5.jpg" width="20" height="23" border="0" id="index_r8_c5" alt="" /></td>
    <td colspan="2"><a href="promo.htm" target="_top" onClick="MM_nbGroup('down','navbar1','index_r8_c7','principal/index_r8_c7_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r8_c7','principal/index_r8_c7_f2.jpg','principal/index_r8_c7_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r8_c7" src="principal/index_r8_c7.jpg" width="84" height="8" border="0" id="index_r8_c7" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="2"><img name="index_r9_c7" src="principal/index_r9_c7.jpg" width="84" height="15" border="0" id="index_r9_c7" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="15" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="10"><img name="index_r10_c1" src="principal/index_r10_c1.jpg" width="31" height="191" border="0" id="index_r10_c1" alt="" /></td>
    <td colspan="7"><a href="faqs.htm" target="_top" onClick="MM_nbGroup('down','navbar1','index_r10_c2','principal/index_r10_c2_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r10_c2','principal/index_r10_c2_f2.jpg','principal/index_r10_c2_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r10_c2" src="principal/index_r10_c2.jpg" width="141" height="8" border="0" id="index_r10_c2" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="7"><img name="index_r11_c2" src="principal/index_r11_c2.jpg" width="141" height="15" border="0" id="index_r11_c2" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="15" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="2" colspan="2"><img name="index_r12_c2" src="principal/index_r12_c2.jpg" width="18" height="23" border="0" id="index_r12_c2" alt="" /></td>
    <td colspan="5"><a href="socios.html" target="_top" onClick="MM_nbGroup('down','navbar1','index_r12_c4','principal/index_r12_c4_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r12_c4','principal/index_r12_c4_f2.jpg','principal/index_r12_c4_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r12_c4" src="principal/index_r12_c4.jpg" width="123" height="8" border="0" id="index_r12_c4" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="5"><img name="index_r13_c4" src="principal/index_r13_c4.jpg" width="123" height="15" border="0" id="index_r13_c4" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="15" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="6"><img name="index_r14_c2" src="principal/index_r14_c2.jpg" width="6" height="145" border="0" id="index_r14_c2" alt="" /></td>
    <td colspan="6"><img name="index_r14_c3" src="principal/index_r14_c3_f2.jpg" width="135" height="8" border="0" id="index_r14_c3" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="6"><img name="index_r15_c3" src="principal/index_r15_c3.jpg" width="135" height="15" border="0" id="index_r15_c3" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="15" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="4" colspan="3"><img name="index_r16_c3" src="principal/index_r16_c3.jpg" width="43" height="122" border="0" id="index_r16_c3" alt="" /></td>
    <td colspan="3"><a href="tips.html" target="_top" onClick="MM_nbGroup('down','navbar1','index_r16_c6','principal/index_r16_c6_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r16_c6','principal/index_r16_c6_f2.jpg','principal/index_r16_c6_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r16_c6" src="principal/index_r16_c6.jpg" width="92" height="8" border="0" id="index_r16_c6" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="3"><img name="index_r17_c6" src="principal/index_r17_c6.jpg" width="92" height="15" border="0" id="index_r17_c6" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="15" border="0" alt="" /></td>
  </tr>
  <tr>
    <td rowspan="2" colspan="2"><img name="index_r18_c6" src="principal/index_r18_c6.jpg" width="31" height="99" border="0" id="index_r18_c6" alt="" /></td>
    <td><a href="contacto.htm" target="_top" onClick="MM_nbGroup('down','navbar1','index_r18_c8','principal/index_r18_c8_f3.jpg',1);" onMouseOver="MM_nbGroup('over','index_r18_c8','principal/index_r18_c8_f2.jpg','principal/index_r18_c8_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="index_r18_c8" src="principal/index_r18_c8.jpg" width="61" height="8" border="0" id="index_r18_c8" alt="" /></a></td>
    <td><img src="principal/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
    <td><img name="index_r19_c8" src="principal/index_r19_c8.jpg" width="61" height="91" border="0" id="index_r19_c8" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="91" border="0" alt="" /></td>
  </tr>
  <tr>
    <td colspan="12" background="principal/index_r20_c1.jpg"><table width="95%" border="0" align="center" cellpadding="2" cellspacing="2">
      <tr>
        <td colspan="3"><div align="center" class="vinculoBolsa">Calle L&aacute;zaro 
          C&aacute;rdenas s/n Col. El Pedregal, C.P. 62790, Xochitepec, Morelos.<br />
          Tels. (01 777) 3614601 Fax. (01 777) 3614598</div></td>
      </tr>
      <tr>
        <td><div align="center" class="vinculoBolsa">ventas@psimexico.com</div></td>
        <td><div align="center" class="vinculoBolsa">produccion@psimexico.com</div></td>
        <td><div align="center" class="vinculoBolsa">direccion@psimexico.com</div></td>
      </tr>
    </table></td>
    <td colspan="2"><img name="index_r20_c13" src="principal/index_r20_c13.jpg" width="208" height="65" border="0" id="index_r20_c13" alt="" /></td>
    <td><img src="principal/spacer.gif" width="1" height="65" border="0" alt="" /></td>
  </tr>
</table>
</body>
</html>