Hey,
I am starting to build a search engine for my site (http://www.neverever.co.uk).
I want to do a FULLTEXT search, but want to do it from multiple tables, and still order by which one has best match, rather than doing separate queries for each tables.
Is this possibly with MySQL by itself, or do I have to use arsort() to fix up the results after the query?
Sorry not to give any example code, but I'm not really sure where to begin. I am sort of at home with single table FULLTEXT selects, but never really attempted multitables before!
Many thanks
Dominic
