That’s why the question about the full text search in the first place :).
One last question rudi regarding this fulltext search, if you don’t mind. I was wondering if there is somehow a way, when adding a company to the database, not only grab the values from the activities chosen, but the display values as well. Because, when that is possible I can add an extra field to the companies table and store those values as a comma delimited list, just for use in the fulltext search.
yeah, you could do that
you would want to set up special column not only for activities but also for categories and cities
remember, a fulltext index cannot span tables, so everything that you want to search on has to be in the same table
you might consider a separate, special company “extra” table, in a 1-to-1 relationship with the companies table
that way, you could have all your tables as innodb, and the extra table as myisam (which is what you need for fulltext indexing)
Hi rudi,
last question I hope 
. What is the best way to grab two values?
one in each hand
I have to admit it’s funny 
But i’m really breaking my head over this. I use CF so what would be the best way?, for example from a list with multiple selections? I don’t want to start adding data before I have this somehow figured. So If you know, please share your deepest secrets, I promise I won’t tell anyone :x
Or is it maybe better to start a new post in the CF forum?
i still don’t understand what you mean by “grab two values”
yes, perhaps it’s better to start a new CF thread