Heres my search code. It's getting the variables from a text field (eg. txtsubcategory) on another page.
<?php
$maxRows_rs_results = 50;
$pageNum_rs_results = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_results'])) {
$pageNum_rs_results = $HTTP_GET_VARS['pageNum_rs_results'];
}
$startRow_rs_results = $pageNum_rs_results * $maxRows_rs_results;
$colname2_rs_results = "1";
if (isset($HTTP_POST_VARS['txtSubcategory'])) {
$colname2_rs_results = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['txtSubcategory'] : addslashes($HTTP_POST_VARS['txtSubcategory']);
}
$colname3_rs_results = "1";
if (isset($HTTP_POST_VARS['txtSkintype'])) {
$colname3_rs_results = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['txtSkintype'] : addslashes($HTTP_POST_VARS['txtSkintype']);
}
$colname_rs_results = "1";
if (isset($HTTP_POST_VARS['txtBrands'])) {
$colname_rs_results = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['txtBrands'] : addslashes($HTTP_POST_VARS['txtBrands']);
}
mysql_select_db($database_razordicom, $razordicom);
$query_rs_results = sprintf("SELECT title, brand, intro, body, image, category, subcategory, skintype FROM products WHERE brand LIKE '%%%s%%' AND subcategory LIKE '%%%s%%' AND skintype LIKE '%%%s%%'", $colname_rs_results,$colname2_rs_results,$colname3_rs_results);
$query_limit_rs_results = sprintf("%s LIMIT %d, %d", $query_rs_results, $startRow_rs_results, $maxRows_rs_results);
$rs_results = mysql_query($query_limit_rs_results, $razordicom) or die(mysql_error());
$row_rs_results = mysql_fetch_assoc($rs_results);
if (isset($HTTP_GET_VARS['totalRows_rs_results'])) {
$totalRows_rs_results = $HTTP_GET_VARS['totalRows_rs_results'];
} else {
$all_rs_results = mysql_query($query_rs_results);
$totalRows_rs_results = mysql_num_rows($all_rs_results);
}
$totalPages_rs_results = ceil($totalRows_rs_results/$maxRows_rs_results)-1;
?>
The problem is that it works fine when I've only got the one colname in but if I add anymore with the AND keyword it doesn't display any results???? Should I create separate recordsets?
Can anyone help??? Please this is realy annoying!
