SQL AND/OR ...Need Help

[Anon]

Heya there!

The code below does not work correctly...
Is ther any problem using AND Description.owner='$owner[0]' OR Description.owner='$owner[1]' ??
Thank you!

Egidio C Santoro

$qry = "SELECT Description.,Detail. ".
"FROM Description,Detail ".
"WHERE Description.id='$id' AND ".
"Description.field='$field' ";

    if ($owner[0] != "Any") { // got $owner from select multiple

$qry .= "AND Description.owner='$owner[0]' ";
$qry .= "OR Description.owner='$owner[1]' ";
}

$qry .= "ORDER BY Description.id";

[Anon]

I have had problems using brackets with my queries before. try assigning them to avriables without brackets before using them:
Also put parantheses around your clauses
Like:
$qry = "SELECT Description.,Detail. ".
"FROM Description,Detail ".
"WHERE ((Description.id='$id') AND ".
"(Description.field='$field') ";

$somevar = $owner[0];
$somevar1 = $owner[1];

if ($somevar != "Any") { // got $owner from select multiple
$qry .= "(AND Description.owner='$somevar') ";
$qry .= "OR (Description.owner='$somevar1') ";
}

$qry .= ")ORDER BY Description.id";

[Anon]

You must enclose your OR statement between parenthesis.

SELECT ..
FROM ...
WHERE description.id = 123
AND ( description.owner = '$owner[0]'
OR description.owner ) '$owner[1]' )
ORDER BY description.id

Hth

JBL

[Anon]

Thank you guys!

It's now working fine!