Page 1 of 1

how to pass and extract string in an array

Posted: Tue Jun 03, 2003 8:22 am
by jiehuang001
For example, I want to build a search box, where the user can input an array of string such as "term1 term2 term3"
then in the action page, I would build a query such as
select * from the_table where the_term like '%term1%' or the_term like '%term2% or the_term like '%term3%'

Of course, the user can input any number of terms. Is there any function to get the individual string in an array?

Thanks.

Jie Huang

Posted: Tue Jun 03, 2003 8:25 am
by Stoker