Syntax probs

Hi,

Can anyone tell me the correct syntax to search for values above or equal to the entered amount in a form:

I tried >= and <= and greater than but it doesnt work!!

would appreciate any ideas - thanks guys!

 

Take out that last and
Also <= & >= work fine.

 

hamidof,

thanks ill try that but it didnt like it last time......ill check again - thanks for your time

 

if i take out the and, i got the error that ' and " cant go next to each other. do i leave a space?

 

Can you post the exact error.
Also it's a very bad idea to query the database with the exact user input, you should take a look at:
http://in2.php.net/mysql_real_escape_string

 

if($_REQUEST[status]!=""){

Try this line like following:
if($_REQUEST['status']!=""){

 

I also think you'll find that you'll do better without the percentage signs on either side of the values you are testing against. I was under the impression that they are used for strings, not numbers...

 

you're right... as well, that multi-IFfy code could be made a little bit more re-readable ;-) i will try to find out a shorter way...