[Resolved] Need Query Help ... Limit by 2 variables w/ <= and >=

busyguy78

Hope someone can help me on this...
I've seen a lot of good threads here so thought I'd try...!

I have a form that sets the variables ...
$min_rent
$max_rent

This gets sent to a php page which should spit out results with a query that limits it to rows where the value in the 'Rent' field is >=$min_rent AND <=$max_rent...

Here is what I have ...

$result1 = mysql_query("SELECT * FROM details Where Rent>='$min_rent' && Where Rent<='$max_rent'",$db);

I am getting no results from this query and I'm setting the values in the form to $0 and $1000000...

SOMETHING should be coming up...

Any help would be greatly appreciated...

mattotto77

I think you should replace && where with just and see below

$result1 = mysql_query("SELECT * FROM details Where Rent>='$min_rent' and Rent<='$max_rent'",$db);

busyguy78

Thanks for the advice..!

That is actually what I started out using...

I switched it back and tried it again...

Still nothing...

If it helps here is some more of the code on the page...
I also have the variables echo'd at the top of the page to make sure they made it across...
When I use the form and the page comes up, I get the variables but no results...
Just the "Sorry, no records were found here!"...

$result1 = mysql_query("SELECT * FROM details Where Rent>='$min_rent' and Where Rent<='$max_rent'",$db);	

if ($myrow1 = mysql_fetch_array($result1))

{

      // This is where the results would be listed

}

else

{

      echo "Sorry, no records were found here!";

}

busyguy78

Oh yeah, one more thing...

I did it with only one variable and it worked...

The query looked like this...

$result1 = mysql_query("SELECT * FROM details Where Rent>='$min_rent'",$db);

This worked fine...

It crapped out when I added the ...

AND Where Rent <='$max_rent'

I also tried...

AND Rent <='$max_rent'

nemonoman

NEVER use 2 'WHERE's in a single query!

$result1 = mysql_query("
SELECT *
FROM details
WHERE Rent>='$min_rent'
AND Rent<='$max_rent'
",$db);

If you can be certain that $min_rent will always be less than or equal to $max_rent, you can also use this construction:

$result1 = mysql_query("
SELECT *
FROM details
WHERE Rent
BETWEEN $min_rent'
AND '$max_rent'
",$db);

Ps. caPitaliZatioN MakEs a diFfErence -- rent or Rent, for example

PPS if Rent is a numeric field, your query will work faster if you DON'T put quotes around '$min_rent' and $max_rent.

busyguy78

The BETWEEN query worked perfectly...!

Thanks for everyone's help...!

This is definitly a great place to bounce problems off of...!