<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">$result doesn't contain the actual
results, but rather the select class. Do something like:<br>
<br>
$data = $result->execute();<br>
<br>
Then data will contain the actual query results object;<br>
<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
On 7/6/2012 4:43 PM, Ms. Nancy Wichmann wrote:<br>
</div>
<blockquote
cite="mid:1341607435.2590.YahooMailNeo@web180316.mail.gq1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:arial,
helvetica, sans-serif;font-size:12pt">
<div><span><font size="2"><span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> $result =
db_select('taxonomy_term_data', 't');</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
$result->addField('t', 'tid');</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
$result->condition('t.vid', $vids, 'IN')</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
->condition(db_or()->condition('t.description',
"%$keys%", 'LIKE')->condition('t.name', "%$keys%",
'LIKE'))</span><br style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> ;</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
$result->execute();</span><br style="font-family:
Courier New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<br style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> $found = NULL;</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> foreach
($result as $row) {</span><br style="font-family:
Courier New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> $output .=
print_r($row, true);</span><br style="font-family:
Courier New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);">
<span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;
background-color: rgb(208, 208, 208);"> }</span><br
style="font-family: Courier
New,courier,monaco,monospace,sans-serif;">
</font>The Devel query log shows the query properly built. I
copied the query from the log into PhpMyAdmin and it gets
one row. But my code shows nothing fetched.</span></div>
<div> </div>
<div><font color="#ff007f" face="bookman old style, new york,
times, serif" size="4"><font style="color:rgb(0, 0, 0);"
size="2"><span style="font-family:arial, helvetica,
sans-serif;"></span></font></font><font color="#ff007f"
face="bookman old style, new york, times, serif" size="4"><i><b>Nancy</b></i></font></div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<br>
</body>
</html>