i am using ZendFrameWork 1.11.5 i need to make a Multi form search queries like i have 5 fields like
name (text box)
city (dropDown)
zipCode (text box)
type (dropdown)
now the problem is ... in text Box user can enter anything it could be correct info or not.. kindly suggest me how to build a fast query.what kind of options i have.. also i tried this but not working.. not giving me correct result..
Select * from table where type = '%$pType%'
OR sex LIKE '%$sex%'
OR race LIKE '%$race%'
OR kind LIKE '%$kind%'
OR country LIKE '%$Country%'
OR state LIKE '%$statesIDs%'
OR zipcode LIKE '%$zip%'";