1.

When we do a SQL query, if we want to pass value to query, we make use %d for integers or %s for strings.

Similarly do we have any place holders for arrays. 

 

 

2.

I am facing a below typical problem, can somebody tell me what should I do?

 

Below query works fine.

SELECT skillid FROM {resubmt_skills}  WHERE resubmt_skills.skillname IN ('PHP', 'HTML', 'SQL')  

 

But in above query search string  'PHP', 'HTML', 'SQL' is hard coded.

I want to make the query generic.

 

Lets say in custom search form, user entered search string PHP, Telecom, HTML,, so how can I write a generic query.

 

Thanks

Austin