Site Search

I'm wondering what is a good general approach to enabling site-wide searches on any topic on a 100% PHP-powered portal-type site for a tertiary institution (yet to be built). Most if not all content will be contained in a database, spread across potentially many different tables. How can all this stuff be searched efficiently and effectively to hopefully find the punter what they're looking for? Searching the sometimes lengthy "main content" fields (eg. an academic paper) in every table of the entire database for every search doesn't seem like the way to go. But apart from attempting to add some kind of subjective "search term" fields to the data, I can't see how else it can be done. TIA ---------------------------------------------------- MICHAEL HALL Web Development Officer Batchelor Institute of Indigenous Tertiary Education Work: mick.hall@nt.gov.au (08) 8951 8314 Home: ninti@ninti.com (08) 8953 1442 ----------------------------------------------------