1 Correct answer
I have copied and pasted the code into a local page. Apart from a missing curly brace after the final line ($query_rsMainItems .= 'neighborhood = ' . GetSQLValueString($_GET['neighborhood'], 'text');), it works perfectly.
The error message says there's an unexpected T_IF on line 66. That means the PHP engine isn't expecting a conditional clause at that point. In all probability, there is an error at an earlier stage in the code, which has resulted in an unmatched brace.
The code that I provided do
...
6
Replies
Okay, let me tell u what the meaning from this code
//select all data from table mainitems
$query_rsMainItems = 'SELECT * FROM mainitems';
//set WHERE as false since WHERE clause isn't use
$where = false;
//check if there's an input from category
if (isset($_GET['category']) && !empty($_GET['category'])) {
//add in previous query by filter it using WHERE clause
$query_rsMainItems .= ' WHERE category = '. GetSQLValueString($_GET['category'], 'text');
//set WHERE as true, means we have use the WHERE clause in query
$where = true;
}
//check if there's an input from price
if (isset($_GET['price']) && !empty($_GET['price'])) {
//check if there's any WHERE set as true from previous query
if ($where) {
//if has, add AND
$query_rsMainItems .= ' AND ';
} else {
//if dont have, use the WHERE
$query_rsMainItems .= ' WHERE ';
//since we have use WHERE clause here, then set is as true
$where = true;
}
//add the variable for AND/WHERE clause
$query_rsMainItems .= 'price = ' . GetSQLValueString($_GET['price'], 'text');
}
My suggesstion is, try to use the code one by one to check what's the problem is, I mean test the code using 'category' input first, if okay then go on with second input(price) and so on. I also been in this situation before I get my code working 
AdChoices