|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Multiple Categories
I am in the process of making an inter-office website.
I can't seem to think of a way to store the data the right way. I can think of ways to do it, but all seem to be too much work. Heres what I need: CREATE TABLE `tickets` ( `ticket_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `ticket_lables` text NOT NULL, `ticket_subject` text NOT NULL, `ticket_content` text NOT NULL, `ticket_status` text NOT NULL, `ticket_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ticket_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; Now, with that in mind, I want to correlate that with the items in this table: CREATE TABLE `labels` ( `labels_id` int(11) NOT NULL auto_increment, `labels_name` text NOT NULL, `labels_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`dept_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; How would I go about storing one or more labels from the lable table (heh) in the tickets table? What way would be the easiest and make the most sense? Thanks, Michael Halvorsen |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Multiple Categories |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|