Can anyone tell me how I can set up the following please?
I need to set up a script that will check to see if a field in a mysql db contains one of a list of words and another field is blank.
For example, if field1 contains red, blue, green or yellow and field4 is blank say yes.
How would I set up the script to show this?
Thanks for any help in advance?