You could try a two step query:
$querywords="CREATE TABLE temptable SELECT ... ";
$sel_querywords=mysql_query($querywords);
$search = "SELECT count(search_table.word) as score,
search_table.qid,page_data.contents
FROM search_table,page_data,temptable
WHERE page_data.pID = search_table.qid AND search_table.word =
temptable.word
GROUP BY search_table.qid
ORDER BY score DESC";
then drop temptable .
HTH
Sorin Ifrim
Scott Mebberson <[EMAIL PROTECTED]> wrote in message
967ab7$t1$[EMAIL PROTECTED]">news:967ab7$t1$[EMAIL PROTECTED]...
> Hi Guys,
>
> I understand that as of version 3.24, MySQL will support subselects. But
> untill then (because 3.23 is the latest stable release) I need to convert
> this SQL satement into something that can be used with v3.2? - the
version
> just before the latest release.
>
> $search = "SELECT count(search_table.word) as score,
> search_table.qid,page_data.contents
> FROM search_table,page_data
> WHERE page_data.pID = search_table.qid AND search_table.word
> IN($querywords)
> GROUP BY search_table.qid
> ORDER BY score DESC";
>
> Does anybody have any ideas, thanks for this guys. Any help is much
> appreciated.
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
