Am trying to ask for one thing or the other to be true, in a mysql query.

ElectricRain

In my form, I have a ID field, and if users enter that, then they need not enter any other data. So, I want my php to match propertys where, the ID matches the posted ID (which it does)
or else where the ID is a blank field and the rest of the fields (rent, postcode etc) match up.
(which it doesnt) it just finds nothing if I enter a invalid ID. Why?

"SELECT 
* 
FROM 
propertys 
WHERE 
id = '$id'
OR 
id = ''
AND
Postcode LIKE '%$postcode%' 
AND
rent BETWEEN '$minrent' and '$maxrent'
AND
price BETWEEN '$minprice' and '$maxprice'
AND $set";

bpat1434

Try this:

$query = "SELECT 
*
FROM 
propertys 
WHERE ";
if(isset($id) && $id != '')
{
   $query  .= "id = '$id'";
}
else
{
    $query .= "OR 
id = ''
AND
Postcode LIKE '%$postcode%'
AND
rent BETWEEN '$minrent' and '$maxrent'
AND
price BETWEEN '$minprice' and '$maxprice'
AND $set";
}

~Brett

ElectricRain

It just throws an error when I dont give it a ID-

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR id = '' AND Postcode LIKE '%%' AND rent BETWEEN '

BuzzLY

Apparently you don't have a $postcode or $rent value, either. Double-check your quotes, too -- you might be missing a quote somewhere.

ElectricRain

Hmm well, it was working code till I started to try n add this either or thing in, so I dont think s'that. If I take out the id bit, or make it so its id= (whatever) AND .. rest of query its ok too.

BuzzLY

Copy and paste your new code here so we can see it. It's hard to help if we don't know what we're dealing with.

ElectricRain

Ah nevermind fixed it. That code gave me the idea though- it works fine if I give it two different querys to pick from depending on whether the ID field is filled. Like:



if(isset($id) && $id != '') 
{
$query = 
"SELECT 
* 
FROM 
propertys 
WHERE 
id = '$id'"; 
 } 

else 
{ 
$query = 
"SELECT 
* 
FROM 
propertys 
WHERE  

Postcode LIKE '%$postcode%' 
AND 
rent BETWEEN '$minrent' and '$maxrent' 
AND 
price BETWEEN '$minprice' and '$maxprice' 
AND $set"; 
}

Thank you neway. 🙂