Hey Michael, <br><br> $query = condition('ubr.rid', '@todo Set the appropriate argument.')<br>Definitely my bad over here.<br><br>should have been<br>$query->condition('ubr.rid', '@todo Set the appropriate argument.')<br>
<br><div class="gmail_quote">On Wed, Oct 12, 2011 at 1:06 PM, Michael Prasuhn <span dir="ltr"><<a href="mailto:mike@mikeyp.net">mike@mikeyp.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">Dipen wrote:<br>
> <a href="http://upgrade.boombatower.com/tools/sql/inline" target="_blank">http://upgrade.boombatower.com/tools/sql/inline</a><br>
><br>
> db_select('user_badges_roles', 'ubr')<br>
> ->fields('ubr', array('rid', 'ubb'))<br>
> ->join('user_badges_badges', 'ubb', 'ubb.bid = ubr.bid')<br>
> ->condition('ubr.rid', '@todo Set the appropriate argument.')<br>
> ->execute();<br>
<br>
</div>1. the fields section is plainly incorrect as it won't select any fields<br>
from user_badges_badges and has an erroneous field from user_badges_roles<br>
<br>
2. Join just returns the tables alias, not a select query object, so<br>
it's not chainable.<br>
<div class="im"><br>
Vaibhav Jain wrote:<br>
> You can use this query like this<br>
</div>> $query = db_select('user_badges_roles', 'ubr')<br>
<div class="im">> ->fields('ubr', array('rid', 'ubb'))<br>
</div>> ->join('user_badges_badges', 'ubb', 'ubb.bid = ubr.bid');<br>
><br>
> $query = condition('ubr.rid', '@todo Set the appropriate argument.')<br>
> ->execute();<br>
<br>
Same problem as number 1 above, and what on earth is the condition<br>
function? I know of no procedural function in Drupal by that name.<br>
<br>
<br>
Nancy, here's what you want:<br>
<br>
$query = db_select('user_badges_roles', 'ubr');<br>
$query->innerJoin('{user_badges_badges', 'ubb', 'ubb.bid = ubr.bid');<br>
$result = $query->fields('ubr', 'rid')<br>
->fields('ubb')<br>
->condition('ubr.rid' $YOUR_ARGUMENT)<br>
->execute();<br>
<br>
There may be a more elegant way to get structure the query, but this<br>
will get you the results you're looking for.<br>
<br>
-Mike<br>
<br>
__________________<br>
<font color="#888888">Michael Prasuhn<br>
<a href="mailto:mike@mikeyp.net">mike@mikeyp.net</a><br>
</font><div><div></div><div class="h5"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Vaibhav Jain<br>