trying to make a loop, cant figure it out

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

•  Subject
• Author
• Posted on
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

Re: trying to make a loop, cant figure it out

Kentor wrote:

use
\$string = "110101010101111010101";
\$numof1s=substr_count(\$string, '1');
\$ans = \$numof1s /2;
I can help you with this part.  The other part I have to look at a
little longer.
and make a table

I

Re: trying to make a loop, cant figure it out

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

Kentor wrote:

Re: trying to make a loop, cant figure it out

strawberry wrote:

That's the hard way to do it.  You have one field which contains multiple
values, which is almost never right.  Rather, have three tables.

Cottage
cottage_id  (other info}

Amenity
amenity_id  amenity_description

Cottage_Amenity
cottage_id  amenity_id

To get a list of amenities for a specific cottage, do:

SELECT amenity_description
FROM Amenity a, Cottage_Amenity ca
WHERE ca.Cottage_id = \$cottageed AND
ca.amenity_id = a.amenity_id