Expression Evaluation Help

thines

Hi folks,

I am having a real bugger with evaulating some result sets.

Here is my code......

$q4 = "select id from i6invites_other
WHERE ((type = 1) OR (type = 2) OR (type = 8) OR (type=10))
AND property_id = $pid";
$result4 = mysql_query($q4,$i6link) or die (mysql_error());
$row4 = mysql_fetch_object($result4)
if (($row4->type!='8' && $row4->type!='10') || ($row4->type!='8' && $row4->type!='1' && $row4->type!='2')) {
echo"blah";
}

I need to display the results if the sql row type returned doesn't contan an (8 and 10)
or (8 and 1 and 2).

For Example...

id -- pid -- type
45 -- 12 -- 8
46 -- 12 -- 1
echo blah.

However....
id -- pid -- type
45 -- 12 -- 8
46 -- 12 -- 10
Don't echo blah.

This of course doesn't work. It is not evaulating my expression properly.

Please help!

-Tim

thines

One Modification.....

Hi folks,

I am having a real bugger with evaulating some result sets.

Here is my code......

$q4 = "select id,type from i6invites_other
WHERE ((type = 1) OR (type = 2) OR (type = 8) OR (type=10))
AND property_id = $pid";
$result4 = mysql_query($q4,$i6link) or die (mysql_error());
$row4 = mysql_fetch_object($result4)
if (($row4->type!='8' && $row4->type!='10') || ($row4->type!='8' && $row4->type!='1' && $row4->type!='2')) {

I need to display the results if the sql row type returned doesn't contan an (8 and 10)
or (8 and 1 and 2).

For Example...

id -- pid -- type
45 -- 12 -- 8
46 -- 12 -- 1
Then Display Results

However....
id -- pid -- type
45 -- 12 -- 8
46 -- 12 -- 10
Don't Display Results

This of course doesn't work. It is not evaulating my expression properly.

Please help!

-Tim

Paulus_Magnus

I don't get it.

You query your database for 1, 2, 8 and 10 but you don't want to display any rows if it's 8 or 10 or 1, 2 or 8.

So you've excluded everything that you queried. scratches head

Is your query expecting to return one row or multiple rows because you don't have for loop for iterating through each returned row.