Anth

Thanks for help.

I tried this option, still get '\' warning.

$skill = "PHP, TML, HTML";
$pieces = explode(",", $skill);
$in_string = "'" . implode("','", $pieces) . "'";

$query = db_query("SELECT name, email, phone, yrsofexp FROM {resubmt_table}
  WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM {resubmt_users_skills}
  WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM {resubmt_skills}
  WHERE resubmt_skills.skillname IN (%s)))", $in_string);

I get the warning

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'PHP\',\' TML\',\' HTML\')))' at line 4 query: SELECT name, email, phone, yrsofexp FROM resubmt_table WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM resubmt_users_skills WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM resubmt_skills WHERE resubmt_skills.skillname IN (\'PHP\',\' TML\',\' HTML\'))) in C:\MyWeb6.20\wamp\www\livejobs1\sites\default\modules\resume_search\resume_search.module on line 126.

Thanks

Austin

On Mon, Apr 11, 2011 at 7:00 AM, Anth <malkouna@yahoo.com.au> wrote:

Sometimes you can't control what you're getting for your IN statement... Try something like: $string = "PHP,HTML,SQL"; $pieces = explode(",", $string); $in_string = "'" . implode("','", $pieces) . "'";

On 6:59 AM, nan wich wrote:

In Drupal code, you should never find a query with %s that is not surrounded by quotes. To do what you are looking for check the db_placeholders function in the API docs.

Nancy

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

From: Austin Einter <austin.einter@gmail.com>
To: support@drupal.org
Sent: Sun, April 10, 2011 8:23:57 PM
Subject: [support] String conversion

Hi

I have a below string.

PHP, HTML, SQL

Want to convert it to

'PHP', 'HTML', 'SQL'

I tried to write a function to do it as below. If I print the function output it prints properly.

If same function output I use for SQL query as below I get warning.

Query: SELECT skillid FROM {resubmt_skills} WHERE resubmt_skills.skillname IN (%s)", $fSkill

Warning: SELECT skillid FROM resubmt_skills WHERE resubmt_skills.skillname IN (\'ITI\',\' PHP\'))) in C:\MyWeb6.20\wamp\www\livejobs1\sites\default\modules\resume_search\resume_search.module on line 140.

Looks it has extra forward slashes. How can I overcome this.

Thanks

Austin

--
[ Drupal support list | http://lists.drupal.org/ ]