IM TRYING TO BE ABLE TO SERACH FROM THREE DROPDOWN MENUS.WITCH IS SIZE...OFFSET...MANUFACTURER...WHILE BEING ABLE TO SERACH WITH ALL THREE MENUES ALL AT ONCE OR BY JUST ONE OR BY JUST TWO
THIS IS WHAT I HAVE...
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_Recordset1 = 20;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$varSize_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Size'])) {
$varSize_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Size'] : addslashes($HTTP_GET_VARS['Size']);
}
$varSize_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Size_2'])) {
$varSize_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Size_2'] : addslashes($HTTP_GET_VARS['Size_2']);
}
$varSize_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Size_3'])) {
$varSize_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Size_3'] : addslashes($HTTP_GET_VARS['Size_3']);
}
$varSize_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Size_4'])) {
$varSize_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Size_4'] : addslashes($HTTP_GET_VARS['Size_4']);
}
$varSize_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Size_5'])) {
$varSize_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Size_5'] : addslashes($HTTP_GET_VARS['Size_5']);
}
$varOffset_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Offset'])) {
$varOffset_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Offset'] : addslashes($HTTP_GET_VARS['Offset']);
}
$varManufacturer_Recordset1 = "%";
if (isset($HTTP_GET_VARS['Manufacturer'])) {
$varManufacturer_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['Manufacturer'] : addslashes($HTTP_GET_VARS['Manufacturer']);
}
mysql_select_db($database_wheel, $wheel);
$query_Recordset1 = sprintf("SELECT * FROM Alba_Tension WHERE (Alba_Tension.Size LIKE '%s%%' OR Alba_Tension.Size_2 LIKE 'varSize_2%%' OR Alba_Tension.Size_3 LIKE 'varSize_3%%' OR Alba_Tension.Size_4 LIKE 'varSize_4%%' OR Alba_Tension.Size_5 LIKE 'varSize_5%%') AND Alba_Tension.Offset LIKE '%s' AND Alba_Tension.Manufacturer LIKE '%s'", $varSize_Recordset1,$varOffset_Recordset1,$varManufacturer_Recordset1);
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $wheel) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
THIS CODE ONLY LETS ME SERCH WITH ALL THREE MENUES AT ONCE..AND ...OFFSET AND MENUFACTURER ONLY...SO I NEED TO BE ABAL TO SERCH ..IN THIS MANOR...SIZE AND OFFSET AND MANUFACTURER...OR SIZE AND OFFFSET....OR SIZE AND MANUFACTURER...OR OFFSET AND MANUFACTURER...OR JUST ONE AT A TIME
CAN SOME ONE HELP ME....😕
