[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
SQL Search II
Hi, I have a form with e.g. 3 textfield (name_1,name_2,name_3).
I want to search :
name_1 should be in field_1 or field_2 or fiel_3
name_2 should be in field_4
name_3 should be in field_5
... what can I do, I use MySQL (Database products products.asc
dbi:mysql:minivend:localhost:3333)
SQL statements like select * from products where field_1 like name_1 or
field_2 like name_1 ,.... make errors ... (see Mail SQL Search).
thx, Kim Armann
