Help with Searching all Values!

PHPAnx

I need help queries all the values in my search. I am able to query each one by itself, but am UNABLE to query all values...

Code:

<select name="productsCat">
<option value="">All Products</option>
<option value="book">Books</option>
<option value="map">Maps</option>
<option value="video">Videos</option>
<option value="misc">Misc</option>
</select>

$sql = "SELECT * FROM products WHERE $prod LIKE ('%".addslashes($search)."%') AND ";
if (isset($REQUEST['productsCat'])) {
$sql .= " productsCat = '" . $REQUEST['productsCat'] . "' ORDER BY productsTitle LIMIT $offset, $sqllimit";
}

Thanks all!!!

nnichols

Try this -

<?

$sql = "SELECT * FROM products WHERE $prod LIKE ('%".addslashes($search)."%') "; 
if (isset($_REQUEST['productsCat'])) { 
	$sql .= " AND productsCat = '" . $_REQUEST['productsCat'] . "'";
	}
$sql .= " ORDER BY productsTitle LIMIT $offset, $sqllimit";

?>

Hope this helps 😉

PHPAnx

Thanks, but that's the same code and all but in a different format. Does the same thing.

Wien

What is the error returned by PHP or MySql ? ?

nnichols

It is not the same code in a different. The logic is quite different, correct where your's was not.

In your code you had -

$sql = "SELECT * FROM products WHERE $prod LIKE ('%".addslashes($search)."%') AND "; 
if (isset($_REQUEST['productsCat'])) { 
$sql .= " productsCat = '" . $_REQUEST['productsCat'] . "' ORDER BY productsTitle LIMIT $offset, $sqllimit"; 
}

if there is a value for $_REQUEST you add the second line of sql, and if not you don't. This is wrong as the ORDER BY and LIMIT clauses should be included in the query regardless of whether or not the user selected a value for "productsCat". Also if there is no value carried through for "productsCat" your query ends with "AND " which will cause MySQL to spit it out because of a syntax error.

I suggest you post your full code.