Make sure you normalise your data. You need to set up a table which contains your requirements ie
id, name 1, visa 2, passport A table for your people id, name 1, samantha 2, johny And then a join id, people_id, requirement_id, 1, 1, 1 2,1,2 3,2,1 4,2,2 You've essentially got a habtm relationship between people and requirements. Look for habtm in the models section of book.cakephp.org Mike Karthauser Brightstorm limited Tel: 07939252144 On 16 Dec 2010, at 09:14, Cruisine <[email protected]> wrote: > hey guys, could anyone help me on how to skip duplicate data from > database. i have this following table: > > ================================ > id | name |requirements | > ================================ > 1 | samantha |passport | > 1 | samantha |visa | > 2 | Johny |passport | > 2 | Johny |visa | > =============================== > > rather than that display, i would like to make the display like the > following : > > ========================= > id | name |requirements | > ========================= > 1 | samantha |passport | > | |visa | > ------------------------------------------------- > 2 | Johny |passport | > | |visa | > ========================= > > > so, how to make it in cakephp ?need ur help soon.. > thx > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
