on <!-- m --><a class="postlink" href="http://phpbuilder.com/columns/clay19990421.php3?page=2">http://phpbuilder.com/columns/clay19990421.php3?page=2</a><!-- m -->
There is this snippet:
SELECT count(search_table.word) as score, search_table.qid,your_table.blob
FROM search_table,your_table
WHERE your_table.qid = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
THe search_table.qid is easy enough to figure out, but what exactly is your_table.blob supposed to be? Should your_table.blob be replaced by the table i want to search in with .blob being the name of the field in that table?
And if so, does this basically mean that I can only search in only one of that tables' fields? Or am I missing something?
I understand that there is a join going on here? But what does that mean? What is going on in this SELECT?
I spent a few days trying to modify Clay's script for taking out words from fields (in my case, i'm using $HTTP_POST_VARS), so I'm halfway there. This last part has me stumped.
Any help, comments or pointers GREATLY appreciated.
Thanks very much for your time and help
There is this snippet:
SELECT count(search_table.word) as score, search_table.qid,your_table.blob
FROM search_table,your_table
WHERE your_table.qid = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
THe search_table.qid is easy enough to figure out, but what exactly is your_table.blob supposed to be? Should your_table.blob be replaced by the table i want to search in with .blob being the name of the field in that table?
And if so, does this basically mean that I can only search in only one of that tables' fields? Or am I missing something?
I understand that there is a join going on here? But what does that mean? What is going on in this SELECT?
I spent a few days trying to modify Clay's script for taking out words from fields (in my case, i'm using $HTTP_POST_VARS), so I'm halfway there. This last part has me stumped.
Any help, comments or pointers GREATLY appreciated.
Thanks very much for your time and help