Posted by strawberry on 10/02/16 11:49

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Kentor wrote:
> hello, im trying to make a little loop, but i cant figure it out... i
> have a string with a bunch of 1s and 0s in it: 110101010101111010101
> ... i need to count the number of 1s divide it by 2 and make a table
> with 2 columns and then for every one, depending on its position in the
> string i need to output a word and then go to the next 1 and output a
> dif word....
>
> its amenities, winter activities and summer activities for cottages
> that i store in my db with 1s and 0s when its a 1 the amenitie or
> whatever exists when its a 0 then it doesent exist...
>
> an example of the kind of table that i need is here:
> http://www.chaletsauquebec.com/FicheChalet.aspx?IdChalet=2011

[Back to original message]