keyword searching mySQL DB

[dancahill]

Hi all,

I'm blundering my way through creating a recruitment website which is going more or less OK but could do with some help pls.

I want to search a mySQL 'text' column with PHP. I am using an HTML form 'text' input type passed to a PHP page. If I only put one search word in the text box then it will correctly pull up relevant details on rows containing that word.

I can't work out how to pass several search terms & make a comparison with words appearing in the text column, i imagine i need to use arrays etc. but can any one point me in the right direction?

Thanks,

Dan

[chriskl]

Use MySQL's fulltext search:

http://www.mysql.com/doc/en/Fulltext_Search.html

Chris

[dancahill]

Sorry meant to put in the post that I am using a MS beta version of mySQL (3.23.22) which doesn't support fulltext.

Dan