[CDBI] Help with multiple OR's.

Jeff MacDonald jeff at interchange.ca
Tue Jul 31 16:44:21 BST 2007


This is the query I'd like to perform.

SELECT * FROM foo WHERE enabled = 1 AND (desc = foo or name = foo)  
AND (country = 1 or province = 9)

I'm trying to build up a $criteria hash to do so.

The problem I'm running to is the -or under the -and is a hash key  
and of course has to be unique. So I can't make 2..

Anyone have suggestions ?


Jeff MacDonald
Interchange Technologies
613 292 6239

More information about the ClassDBI mailing list