Posted by J.O. Aho on 11/24/05 15:27

Harry wrote:
> Hi!
>
> What kind of var should I use to store some words in a field?
>
> For instance, I would like to save some key words for each user. How can
> I achieve it?
>
> USER KEY WORDS
> john family,sports,basket,pete
> lucas mirror,dog,soccer
>
> I can't use SET var because the words can be different, defined by the
> user.
>
> I have thought of using some fields such as KEYWORD1 KEYWORD2 KEYWORD3,
> and store a string, but I don't want to limit the user.

You can allow multiple rows for a user, each including one word as the
keyword, this way you won't limit the user and you will give a quite good many
possible keywords to use.


//Aho

[Back to original message]