<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><span style="font-size: 13px;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> $result = db_query("SELECT id, exp, name FROM {resubmt_users_skills} LEFT JOIN {resubmt_skill_ids} USING (id) WHERE resubmt_users_skills.uid = :uid", array(':uid' => $user.uid))->fetchAssoc();</span></span><br><br>That should work just fine and doesn't require the overhead of dynamic queries. I'm not too sure about the fetchAssoc() because I don't bother with array results any more.<br><br>See <a href="http://drupal.org/node/310072">http://drupal.org/node/310072</a><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><b>Nancy</b></i></font> <br></div><div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.</font></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Kamal Palei</font><br></div><br><div id="yiv1743188237"><div>Thanks <font color="#000000">Nicolas</font><br>Tried your suggestion. It worked. Thanks.</div>
<div> </div>
<div>Nancy, I did not understand your comment "do not convert select query", can you kindly elaborate on it.<br> </div></div></div> </div> </blockquote></div> </div></body></html>