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
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_ta
2 matches
Mail list logo
