Re: [PHP] Re: Best Approach for Multiple Options

[Marek Kilimajer]

Use SET column type if you want. But there is a limit for how many 
members can the SET type have (64 in MySQL).

I would go with the first approach.

Kae Verens wrote:
this will return true for something like 'pool|fireplace|fitness'
mysql_query('select id from theTable where amenities like "%pool%"')
you could make it more efficient by using boolean logic:
if 1=pool,2=fireplace,4=fitness, then 3=fireplace+pool, 5=fitness+pool, 
7=fitness+fireplace+pool

just thoughts.

Kae

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php