Generate SQL statement by logical function

[mshen]

I have some sql statements like

Condition 1

select * from db1 where item1=1

Condition 2

select * from db1 where item2='a'

.....

Condition n

select * from db1 where itemn='abc'

I need generate SQL statements based on logical functions.for example

condition1 AND condition2 OR condition3 NOT condition 4

....

...

I need genarate many SQL statements with different logical functions.

please show me how to do it with PHP.

thanks

[mshen]

How to do it if the logic is very complex?

like

[Filter1] AND NOT ([Filter2] OR [Filter3])

([Filter1] AND [Filter2]) OR ([Filter1] AND [Filter3])

Thanks

[kamy99]

it seems to me you need to use multiple if/else statements or switch statments. Or a combination of both!

HTH