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); ?> PSI MEXICO [ Plant Source International México ]

Calle Lázaro Cárdenas s/n Col. El Pedregal, C.P. 62790, Xochitepec, Morelos.
Tels. (01 777) 3614601 Fax. (01 777) 3614598
ventas@psimexico.com
produccion@psimexico.com
direccion@psimexico.com