leonardburton
12-07-2004, 08:43 PM
Greetings,
Would anyone know if this can be done in an SQL statement?
At the bottom of my PHPDIG search results I have special links inserted for certain queries. I am currently only filtering for certain one word phrases (which was very easy) but I want to have two word + phrases.
For example, if in the MYSQL table I have stored:
one two three
and the PHPDIG search query is:
one two three four
I want it to return the special link for "one two three."
I tried "select link from table where '$query' like keyword" but obviously that didnt work.
Is there a way to do that without having to put all the keywords in an array and loop through it?
Thanks,
Leonard
Would anyone know if this can be done in an SQL statement?
At the bottom of my PHPDIG search results I have special links inserted for certain queries. I am currently only filtering for certain one word phrases (which was very easy) but I want to have two word + phrases.
For example, if in the MYSQL table I have stored:
one two three
and the PHPDIG search query is:
one two three four
I want it to return the special link for "one two three."
I tried "select link from table where '$query' like keyword" but obviously that didnt work.
Is there a way to do that without having to put all the keywords in an array and loop through it?
Thanks,
Leonard