Hello,
I have tables in a user administration database and need to link different
tables with FK's.
How do I do this?
for example:
I have two tables, one called applications, the other called
forum_moderators.
Applications Catches all form submissions.
Forum_Moderators hold the details of active/current moderators
I want to link these two tables by rsm_id in applications, and fk_rsm_id in
forum_mod's.
How would i do this in MySQL and or PHP?
Table Structure:
for those that need a clearer picture of my layout, I have supplied the SQL
statement to create the tables
#--------------------------------------------------------
#
# Table structure for table 'applications'
#
DROP TABLE IF EXISTS applications;
CREATE TABLE `applications` (
`rsm_id` tinyint(4) NOT NULL auto_increment,
`first_name` varchar(20) NOT NULL default '',
`last_name` varchar(20) NOT NULL default '',
`city` varchar(10) NOT NULL default '',
`state` char(2) NOT NULL default '',
`dob` varchar(10) NOT NULL default '',
`forum_nick` varchar(20) NOT NULL default '',
`forum_select1` varchar(30) NOT NULL default '',
`forum_select2` varchar(30) NOT NULL default '',
`forum_select3` varchar(30) NOT NULL default '',
`bio` blob NOT NULL,
`email_addr` varchar(100) NOT NULL default '',
`processed` set('0','1') NOT NULL default '',
`add_date` date NOT NULL default '0000-00-00',
`accept_denied` set('A','D') NOT NULL default '',
`acc_dec_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`rsm_id`),
UNIQUE KEY `email_addr` (`email_addr`),
UNIQUE KEY `forum_nick` (`forum_nick`),
UNIQUE KEY `rsm_id` (`rsm_id`),
KEY `rsm_id_2` (`rsm_id`),
KEY `forum_nick_2` (`forum_nick`),
KEY `email_addr_2` (`email_addr`)
#--------------------------------------------------------
#
# Table structure for table 'forum_moderators'
#
DROP TABLE IF EXISTS forum_moderators;
CREATE TABLE `forum_moderators` (
`formod_id` tinyint(4) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`city` varchar(10) NOT NULL default '',
`state` char(2) NOT NULL default '',
`forum_nick` varchar(20) NOT NULL default '',
`mod_forum_1` varchar(30) NOT NULL default '',
`mod_forum_2` varchar(30) NOT NULL default '',
`mod_forum_3` varchar(30) NOT NULL default '',
`email_addr` varchar(100) NOT NULL default '',
`tremination_date` date default NULL,
`fk_rsm_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`formod_id`),
UNIQUE KEY `formod_id` (`formod_id`,`forum_nick`),
KEY `formod_id_2` (`formod_id`)
) TYPE=MyISAM;
#--------------------------------------------------------
#--------------------------------------------------------
Regards,
Charlie
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php