
March 8th, 2008, 06:36 AM
|
|
Registered User
|
|
Join Date: Mar 2008
Posts: 1
Time spent in forums: 47 m 20 sec
Reputation Power: 0
|
|
|
Search with mysql and between
Hello, I have problem with search.
I using between
"SELECT * FROM search2 WHERE `price` BETWEEN $low AND $max ORDER by price";
);
ok it's working but not working:
"SELECT * FROM search2 WHERE `price` BETWEEN $low AND $max AND `name` = '$name' AND `other` = '$other'";
);
I need do it in one sentence when i remove between then working `name` = '$name' AND `other` = '$other' BUT when i delete it, then working between,  I need to it works too.
I need like : "SELECT * FROM search2 WHERE `price` BETWEEN $low AND $max AND `name` LIKE '$name' AND `other` LIKE '$other'";
);
To work, but it's not working, no errors. I try OR and = but it's not work, please help 
|