Sean,

At 12:29 PM 30/01/2006, you wrote:

>Hey All
>
>I would like to use Firebird for a project that I am working on. The
>project has a requirement for a full text search engine, and I have
>poked about with the IBO FTS stuff, with some success. My problem is,
>that the database ALSO needs to be accessible and searchable from a php
>based website. Now, I have no problems with php and firebird, having
>worked with them together a lot. My problem is that I have to be able
>to carry out the same type of search in php as I can in my win32
>application. Any pointers to the SQL I would have to construct to do
>this? I would way rather not have to use MySQL, so any help here would
>be greatly appreciated.

Setting up FTS using IBO you already know about. It's all in the
database once it's done - triggers, SPs, the lot. (Only YOU know
exactly what you did!)

Make sure that your selectable SPs are squeaky clean and totally
parameterised - then you can invoke the FTS from anywhere that
supports a select statement and parameters!

Once you have the search stuff in place to your satisfaction, use
IB_SQL or some equivalent tool to output your metadata and start
composing your queries!

This forum isn't the place to teach you how to write queries so, if
your SQL isn't sharp enough, get a book! There are some
recommendations on the IBO website. SQL for Dummies, 2nd Edition,
seems a pretty good reference for standard SQL, plus (I was told) it
used InterBase for its examples. The Dummies books tend to be
relatively inexpensive, too, and you can often pick them up
second-hand through Amazon or eBay.

Helen