[RESOLVED] Using EIN = '$fin" AND PNO LIKE ... issue!

[spiritssight]

Hello all,

I have my script working and all but there is one thing that its not doing as it should and that is allowing me to have more then on WHERE cluase thing.

My code for that area is:

echo "We are now checking if record ". $record_id ." matchs the required criteria!<br />";
$query_is = "INSERT INTO query SELECT * FROM irs_rawdata 
WHERE (EIN = '$fin' AND PNO LIKE '%blind%' OR PNO LIKE '%deaf%')";

$result_is = mysql_query($query_is);
$count = mysql_affected_rows();

as you can see I have more then one rule under WHERE cluase, when it is setup like that all of them say it matches when it does not there is only 8 out of 500 that match these rules of having deaf or blind in the name am I doing some thing wrong or what? I have about 20ish more rules (OR LIKE) to add to this query

Thanks for any help!

Sincerely,
Christopher

[NogDog]

The AND operator has precedence over the OR operator. So your current WHERE clause has the following functional meaning:

WHERE (EIN = '$fin' AND PNO LIKE '%blind%' ) OR PNO LIKE '%deaf%'

Therefore, a record will match if both of the first two conditions are true, or if the 3rd condition is true regardless of whether the first 2 are.

I'm guessing this is not the precise logic you want, but of course I don't know for sure. My guess is that perhaps what you want is:

WHERE EIN = '$fin' AND (PNO LIKE '%blind%' OR PNO LIKE '%deaf%')

[spiritssight]

Great that work, but once I add more then the two thats in the () it and says all of them match

[laserlight]

What did you try now?

[spiritssight]

it works now :-) it was my error!

Thanks a lot folks for the help! soon I will post to the code criting to hopfully get some good tips to make the code better!

Sincerely,
Christopher

[spiritssight]

the question I now have is is there a way to have a file with the WHERE stuff?

Sincerely,
Christopher

[laserlight]

the question I now have is is there a way to have a file with the WHERE stuff?

What do you mean by "a file with the WHERE stuff"?

[spiritssight]

I have a list of over 20 things that the record could match it needs to match the fin and one of the other 20ish where rules this list will grow over time to be alot more

[laserlight]

What is your relevant database schema (i.e., the tables involved, their columns and relationships), and what exactly are you trying to select?

[spiritssight]

its one table that it automatic filters and then a human filters the table that the match ones from the first one goes into

table 1 has say 100 records only 36 match the rules say 4 rules which are under or .. or .. etc them 36 records are then inserted into a table for human filtering, still the exact same layout and so on as the first table.

does this answer the question if not can you explain so I can understand?

Sincerely,
Christopher