Lines Matching refs:result
130 $result = mysql_query ("SELECT ID,Count FROM Queries WHERE Value='$word'");
131 if ($result) {
132 $i = mysql_num_rows($result);
134 mysql_free_result($result);
137 $id = mysql_result($result, 0, 0);
138 $count = mysql_result($result, 0, 1);
147 $result = NULL;
150 $result = mysql_query ("SELECT words.relevance, symbols.name, symbols.type, symbols.module, symbols.descr FROM words, symbols WHERE LCASE(words.name) LIKE LCASE('$word') and words.symbol = symbols.name ORDER BY words.relevance DESC LIMIT 75");
151 if ($result) {
152 $j = mysql_num_rows($result);
154 mysql_free_result($result);
158 return array($result, $j);
161 $result = NULL;
164 $result = mysql_query ("SELECT relevance, name, id, resource, section FROM wordsHTML WHERE LCASE(name) LIKE LCASE('$word') ORDER BY relevance DESC LIMIT 75");
165 if ($result) {
166 $j = mysql_num_rows($result);
168 mysql_free_result($result);
172 return array($result, $j);
175 $result = NULL;
178 $result = mysql_query ("SELECT wordsArchive.relevance, wordsArchive.name, 'xml-list', archives.resource, archives.title FROM wordsArchive, archives WHERE LCASE(wordsArchive.name) LIKE LCASE('$word') and wordsArchive.ID = archives.ID ORDER BY relevance DESC LIMIT 75");
179 if ($result) {
180 $j = mysql_num_rows($result);
182 mysql_free_result($result);
186 return array($result, $j);
189 $result = NULL;
192 $result = mysql_query ("SELECT XSLTwords.relevance, XSLTsymbols.name, XSLTsymbols.type, XSLTsymbols.module, XSLTsymbols.descr FROM XSLTwords, XSLTsymbols WHERE LCASE(XSLTwords.name) LIKE LCASE('$word') and XSLTwords.symbol = XSLTsymbols.name ORDER BY XSLTwords.relevance DESC LIMIT 75");
193 if ($result) {
194 $j = mysql_num_rows($result);
196 mysql_free_result($result);
200 return array($result, $j);
203 $result = NULL;
206 $result = mysql_query ("SELECT relevance, name, id, resource, section FROM XSLTwordsHTML WHERE LCASE(name) LIKE LCASE('$word') ORDER BY relevance DESC LIMIT 75");
207 if ($result) {
208 $j = mysql_num_rows($result);
210 mysql_free_result($result);
214 return array($result, $j);
217 $result = NULL;
220 $result = mysql_query ("SELECT XSLTwordsArchive.relevance, XSLTwordsArchive.name, 'xslt-list', archives.resource, archives.title FROM XSLTwordsArchive, archives WHERE LCASE(XSLTwordsArchive.name) LIKE LCASE('$word') and XSLTwordsArchive.ID = archives.ID ORDER BY relevance DESC LIMIT 75");
221 if ($result) {
222 $j = mysql_num_rows($result);
224 mysql_free_result($result);
228 return array($result, $j);
250 list($result, $j) = queryWord($word);
253 $relevance = mysql_result($result, $i, 0);
254 $name = mysql_result($result, $i, 1);
255 $type = mysql_result($result, $i, 2);
256 $module = mysql_result($result, $i, 3);
257 $desc = mysql_result($result, $i, 4);
270 mysql_free_result($result);
275 list($result, $j) = XSLTqueryWord($word);
278 $relevance = mysql_result($result, $i, 0);
279 $name = mysql_result($result, $i, 1);
280 $type = mysql_result($result, $i, 2);
281 $module = mysql_result($result, $i, 3);
282 $desc = mysql_result($result, $i, 4);
295 mysql_free_result($result);
300 list($result, $k) = queryHTMLWord($word);
303 $relevance = mysql_result($result, $i, 0);
304 $name = mysql_result($result, $i, 1);
305 $id = mysql_result($result, $i, 2);
306 $module = mysql_result($result, $i, 3);
307 $desc = mysql_result($result, $i, 4);
317 mysql_free_result($result);
322 list($result, $k) = XSLTqueryHTMLWord($word);
325 $relevance = mysql_result($result, $i, 0);
326 $name = mysql_result($result, $i, 1);
327 $id = mysql_result($result, $i, 2);
328 $module = mysql_result($result, $i, 3);
329 $desc = mysql_result($result, $i, 4);
338 mysql_free_result($result);
343 list($result, $j) = queryArchiveWord($word);
346 $relevance = mysql_result($result, $i, 0);
347 $name = mysql_result($result, $i, 1);
348 $type = mysql_result($result, $i, 2);
349 $url = mysql_result($result, $i, 3);
350 $desc = mysql_result($result, $i, 4);
364 mysql_free_result($result);
369 list($result, $j) = XSLTqueryArchiveWord($word);
372 $relevance = mysql_result($result, $i, 0);
373 $name = mysql_result($result, $i, 1);
374 $type = mysql_result($result, $i, 2);
375 $url = mysql_result($result, $i, 3);
376 $desc = mysql_result($result, $i, 4);
390 mysql_free_result($result);
398 list($result, $j) = queryWord("xml$word");
401 $relevance = mysql_result($result, $i, 0);
402 $name = mysql_result($result, $i, 1);
403 $type = mysql_result($result, $i, 2);
404 $module = mysql_result($result, $i, 3);
405 $desc = mysql_result($result, $i, 4);
418 mysql_free_result($result);
423 list($result, $j) = XSLTqueryWord("xslt$word");
426 $relevance = mysql_result($result, $i, 0);
427 $name = mysql_result($result, $i, 1);
428 $type = mysql_result($result, $i, 2);
429 $module = mysql_result($result, $i, 3);
430 $desc = mysql_result($result, $i, 4);
443 mysql_free_result($result);