Posted by Jim S. on 02/05/06 04:26

well J.O. Aho i thought about the multiselect, but the problem is , i
have so many options, but i want only 4 or 5 to be selcted, and i do not
know how to limit the multi select to just 4 or 5 (out of let us say 10)

furthermore, the select/menu is part of a bigger form, and am afraid that
"multi select could confuse the PP out of them ;)

do u have any note on, can i store an array in a database? and how?
code please if it is not too much trouble :D
thanks again
Jim

> Why not make it simple to make one multiselect list
>
> <SELECT MULTIPLE SIZE=5 NAME="features[]">
> <OPTION VALUE="o1">Option 1
> <OPTION VALUE="o2">Option 2
> <OPTION VALUE="o3">Option 3
> <OPTION VALUE="o4">Option 4
> <OPTION VALUE="o5">Option 5
> <OPTION VALUE="o6">Option 6
> </SELECT>
>
>
>> i succeeded to have the value ( for my example) 0,0,0,0,5,0,0
>> now i want to get the value of $all in the database, (so i can spit it
>> out later with an "echo" or something)
>> i made a field in the database with ENUM, with the "list" inserted in
>> it sequetially
>
> Say your list gets longer and you have 15 to select from, and you want to
> look for say five (5), you will get more trouble with your search query as
> the five could be the first, last or somewhere in the middle, you need to
> think about the commas as you can search fro just '%5%' as this would
> return the users who has selected 15.
>
> This makes it a lot more difficult to search IMHO, I would rather have a
> table where I save the userid and the value where the userid+value is the
> key (to prevent multiples of the same result in the table).
>
>
>
> //Aho

[Back to original message]