anyway, move along,.. I've already solved the problem without your help, but from others on this list.
John Nichel wrote:
Sebastian wrote:
I'd like to know if it is possible to perform a search across multiple mysql tables within a single query.
eg, i have two tables with different column names:
news: title | newstext
faqs: topic | faqstext
currently i am just searching the news table with a query as such:
SELECT *, MATCH (topic,newstext) AGAINST ('$queryword') AS score FROM news
would i have to run a second query to display results from the 'faqs' table?
http://lists.mysql.com http://dev.mysql.com/doc/mysql/en/index.html
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
