Re: Complicated query... is there a simpler way?

On Wed, Jun 27, 2001 at 02:24:24AM +0100, Ryan Mahoney wrote:
> *Disclaimer* - me sleepy, no guarantee of intelligebility or relevence ;)
>
> First thing that strikes me is that you should use varchar datatype for
> almost all of your fields with the exception of the body within posts.
>
> If I were working on this project, I would...

</lurk>
slaver slaver

> If you are interested in this approach, I can send you some PHP files (for
> indexing documents and performing searches) and a stored procedure that
> performs this type of search.  The biggest downside of this method is that
> maintaining the keyword and relationships can become a serious management
> nightmare, especially if users can revise their posted messages.

i'm game, drool drool. sign me up!

--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
    - Tod Steward

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!