Hi,
I'm attempting to build a search engine for my site (currently running on my computer, win XP home, apache, PHP, MySQL 3.23.53).
What I've done so far is created a function populate, that runs every time a file is edited (all files are edited by forms, using HTMLArea- very nice...). Other pages that are edited can be manually parsed into the DB by running a script and entering the required URL, the populate function then runs. This functions puts a row in the table "search". The row contains an ID, the UNIX tstamp of the last update, the words on the page, separated by spaces (between two HTML comments specifying start of content and end of content, to prevent menus and things being in the searches), and the words on the page, with minimal formatting to allow it to be output in the search results.
My question is, where do I begin with my MySQL command to search the table?
I'm guessing that having the IN BOOLEAN MODE switch available may be handy, but I'm running 3.23.53, not 4.01 as would be required, is this worth an upgrade? How complicated would it be to upgrade? Is there a work around for my version?
Many thanks,
ucbones
