strawberry wrote:
http://dev.mysql.com/tech-resources/...alization.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/Fiche...?IdChalet=2011
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
And google "database normalization" for more information on how to normalize
tables correctly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================