Search Option

[NZ_Kiwis]

I've got a string of data let's say

"I love PHP and not Java"

I've also got a table of data where I have keywords such as

.NET
Java
PHP

I want to do a random search where one of the words matches something in my database.

HOw can I do this? I know the random search part just not marching part of my string.

[NZ_Kiwis]

Can I explode my string into a array and search for where PicWord is = (MyArray) or where PicWord IN (MyArray) something like that?

[DaveRandom]

I don't quite understand what you are trying to do here - it sounds as if you could just do it with strpos() or some construction involving in_array().

It's the "random search" part I don't understand.

If this does not help, please elaborate with more examples.

[NZ_Kiwis]

I have a news item title, i want to loop through a table in my database and find a keyword from a column in this table where it matches a word in my news title.

[DaveRandom]

If I understand you right, this would be much easier to do the other way round... have a list of keywords and see if any of them is in the title, using strpos() or similar.

The only way I can think of doing it that way round is to explode() your title into seperate words and test each of them against the DB individually.