Re: [support] Place holders in SQL query

On Sun, Apr 10, 2011 at 6:55 PM, Austin Einter austin.einter@gmail.com wrote:

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.

There's a handy function you need called db_placeholders -

http://api.drupal.org/api/drupal/includes--database.inc/function/db_placehol...

There are some examples on that page, but if you want more help be sure to provide more of your example code.

Cheers, Greg