<div>Thanks Greg. Inching closer. Got partial result.</div>
<div> </div>
<div> $skill = "SQL, PHP";<br> $pieces = explode(",", $skill);<br> <br> $query_string = 'SELECT name, email, phone, yrsofexp FROM {resubmt_table} ' . <br> 'WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM {resubmt_users_skills} ' . <br>
'WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM {resubmt_skills} ' . <br> 'WHERE resubmt_skills.skillname IN ( ' . db_placeholders($pieces, 'varchar') . ')))';<br> <br> $query = db_query($query_string, $pieces);</div>
<div> </div>
<div>This gives records having skill set only SQL.</div>
<div> </div>
<div>If I change $skill as below</div>
<div> </div>
<div> $skill = "PHP, SQL";</div>
<div> </div>
<div>I get records having PHP skill only.</div>
<div> </div>
<div>So it is only taking the first element of array. I wanted it to take all the arguements in array.</div>
<div> </div>
<div>Thanks</div>
<div>Austin</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Mon, Apr 11, 2011 at 8:15 AM, Greg Knaddison <span dir="ltr"><<a href="mailto:greg@growingventuresolutions.com">greg@growingventuresolutions.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">On Sun, Apr 10, 2011 at 8:35 PM, Austin Einter <<a href="mailto:austin.einter@gmail.com">austin.einter@gmail.com</a>> wrote:<br>> Hi All<br>> On further exploring..<br>><br>> $skill = "PHP, TML, HTML";<br>
> $pieces = explode(",", $skill);<br>><br>> $query_string = 'SELECT name, email, phone, yrsofexp FROM {resubmt_table} '<br>> .<br>> 'WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM<br>
> {resubmt_users_skills} ' .<br>> 'WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM<br>> {resubmt_skills} ' .<br>> 'WHERE resubmt_skills.skillname IN ( ' . db_placeholders($pieces,<br>
> 'varchar') . ')))';<br>><br>> drupal_set_message($query_string);<br>> $query = db_query($query_string);<br>><br>><br>> The output prints as<br>><br>> SELECT name, email, phone, yrsofexp FROM {resubmt_table} WHERE<br>
> resubmt_table.uid IN (SELECT DISTINCT uid FROM {resubmt_users_skills} WHERE<br>> resubmt_users_skills.skillid IN(SELECT skillid FROM {resubmt_skills} WHERE<br>> resubmt_skills.skillname IN ( '%s','%s','%s')))<br>
><br>> But I do not see , pieces[0], pieces[1] and pieces[2] etc in query string.<br>> Is it fine or I am doing something wrong here.<br>><br><br></div>You are close, but you need one last piece:<br>
<div class="im"><br>$query_string = 'SELECT name, email, phone, yrsofexp FROM {resubmt_table} ' .<br> 'WHERE resubmt_table.uid IN (SELECT DISTINCT uid FROM<br>{resubmt_users_skills} ' .<br> 'WHERE resubmt_users_skills.skillid IN(SELECT skillid FROM<br>
{resubmt_skills} ' .<br> 'WHERE resubmt_skills.skillname IN ( ' . db_placeholders($pieces,<br>'varchar') . ')))';<br><br> drupal_set_message($query_string);<br></div> $query = db_query($query_string, $pieces);<br>
^^^^^^^^^^^^^^^^^^<br><br>The $pieces as an argument to $db_query should get it done.<br><br>Also, for debugging sql I love using the Devel module and enabling<br>query logging and printing the query log. It shows the exact query<br>
without having to do a drupal_set_message and after any argument<br>substitution takes place.<br><br>Cheers,<br>Greg<br><font color="#888888"><br>--<br>Greg Knaddison | 720-310-5623 | <a href="http://growingventuresolutions.com/" target="_blank">http://growingventuresolutions.com</a><br>
<a href="http://masteringdrupal.com/" target="_blank">http://masteringdrupal.com</a> - Videos and Tutorials<br></font></blockquote></div><br>