I have 3 tables with various options a user can select which are all HABTM
(TOOLS ->hammer, measuring tape, level, screwdriver.......)
(EQUIPMENTS ->drill, saw, router .......)
(SUPPLIES ->nails, screws, bolts.......)
If I made a table called CATEGORIES (id title)
Could or should I put them all in one table such as OPTIONS and break them
into groups such as
OPTIONS TABLE
id
category_id
title
so tools in the db look like
1 1 hammer
2 1 measuring tape
3 1 screwdriver
4 2 drill
5 2 saw
6 2 router
7 3 nails
8 3 screws
9 3 bolts
Rather than having extra tables put them all into one?
And if I do that can I then display them in sections when using the echo
$form->input('Option',array('multiple'=>'checkbox')); if I added a category
=> whatever I wanted to display?
Thanks guys
Dave
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
