Simple condition checking help?

[Mr Chris]

Hi All,

 

I have a very simple piece of condition checking that I’m having trouble with:

 

I only want to use this condition IF $from_price OR $to_price is empty then don't add the below query:

 

    if(!empty($from_price) || ($to_price)) 
    { 
      $add .= " AND price BETWEEN '$from_price' AND '$to_price'";   
    }

 

However, if $from_price has a value and $to_price does not it still outputs this condition (and vice versa).

 

Can anyone help?

 

Thanks

 

 

[Baabu]

if(isset($from_price) && isset($to_price)) 
    { 
      $add .= " AND price BETWEEN '$from_price' AND '$to_price'";   
    }

try this ...if both are set then this query will be added..else not

[Mr Chris]

Thanks,  Just one more i'm stuck with on a condition check.

 

If $bathroom is not empty and less than 4 otherwise use the other condition

 

    if(!empty($bathrooms) && $bathrooms < '4') 
    { 
      $add .= " AND bathrooms = '$bathrooms'"; 
    } 

    if(!empty($bathrooms) && $bathrooms > '5') 
    { 
      $add .= " AND bathrooms > '5'"; 
    } 

[Mr Chris]

Doh, that does work!  Please ignore me, thanks anyway!!

[revraz]

You should probably wrap this though

 

$bathrooms > '5' to ($bathrooms > 5)