ok i am having some problems with linking tables i have tried various methods but the there not coming out right anyway this time i have posted my tables which i have created in databace i need to know if the done corectly for what i need or i should change them if anyone could help me please at least i will know if there ok .
what i wanted to do is link these stables together with the stable name
so only that stables stats show up i will put them in the apropiot boxes in page once its linked up corectly
ok here the tables
CODE
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_dirt`
--
CREATE TABLE `horse_g_dirt` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(5) NOT NULL,
`3.2m` varchar(5) NOT NULL,
`3.3m` varchar(5) NOT NULL,
`3.4m` varchar(5) NOT NULL,
`3.5m` varchar(5) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_dirt`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_firm`
--
CREATE TABLE `horse_g_firm` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(5) NOT NULL,
`3.2m` varchar(5) NOT NULL,
`3.3m` varchar(5) NOT NULL,
`3.4m` varchar(5) NOT NULL,
`3.5m` varchar(5) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_firm`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_good`
--
CREATE TABLE `horse_g_good` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_good`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_hard`
--
CREATE TABLE `horse_g_hard` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_hard`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_heavy`
--
CREATE TABLE `horse_g_heavy` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_heavy`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_g_soft`
--
CREATE TABLE `horse_g_soft` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_g_soft`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_ground`
--
CREATE TABLE `horse_ground` (
`key id` int(11) NOT NULL auto_increment,
`name_id` varchar(50) NOT NULL,
`hard` varchar(5) NOT NULL,
`firm` varchar(5) NOT NULL,
`good` varchar(5) NOT NULL,
`soft` varchar(5) NOT NULL,
`heavy` varchar(5) NOT NULL,
`dirt` varchar(5) NOT NULL,
`stable_name` varchar(50) NOT NULL,
PRIMARY KEY (`key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_ground`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_stats`
--
CREATE TABLE `horse_stats` (
`Key id` int(11) NOT NULL auto_increment,
`name_id` varchar(40) NOT NULL,
`age` varchar(10) NOT NULL,
`gen` varchar(10) NOT NULL,
`bred` varchar(10) NOT NULL,
`xp` varchar(10) NOT NULL,
`height` varchar(10) NOT NULL,
`weight` varchar(10) NOT NULL,
`heart` varchar(20) NOT NULL,
`stamina` varchar(20) NOT NULL,
`muscle_tone` varchar(20) NOT NULL,
`acceleration` varchar(20) NOT NULL,
`gate speed` varchar(20) NOT NULL,
`medical_condition` varchar(20) NOT NULL,
`physical_condition` varchar(20) NOT NULL,
`ran` varchar(10) NOT NULL,
`won` varchar(10) NOT NULL,
`shown` varchar(10) NOT NULL,
`winnings` varchar(20) NOT NULL,
`stable_name` varchar(50) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_time`
--
CREATE TABLE `horse_time` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_time`
--
-- --------------------------------------------------------
--
-- Table structure for table `horse_train`
--
CREATE TABLE `horse_train` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
`hard` varchar(5) NOT NULL,
`firm` varchar(5) NOT NULL,
`good` varchar(5) NOT NULL,
`soft` varchar(5) NOT NULL,
`heavy` varchar(5) NOT NULL,
`dirt` varchar(5) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `horse_train`
--
-- --------------------------------------------------------
--
-- Table structure for table `jocky_stats`
--
CREATE TABLE `jocky_stats` (
`key id` int(11) NOT NULL auto_increment,
`Jocky_name` varchar(30) NOT NULL,
`age` varchar(10) NOT NULL,
`run` varchar(10) NOT NULL,
`won` varchar(10) NOT NULL,
`place` varchar(10) NOT NULL,
`moral` varchar(20) NOT NULL,
`rating` varchar(20) NOT NULL,
`winnings` varchar(20) NOT NULL,
`stable_name` varchar(50) NOT NULL,
PRIMARY KEY (`key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `jocky_stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `jocky_train`
--
CREATE TABLE `jocky_train` (
`Key id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`stable_name` varchar(50) NOT NULL,
`5f` varchar(6) NOT NULL,
`6f` varchar(6) NOT NULL,
`7f` varchar(6) NOT NULL,
`1mile` varchar(6) NOT NULL,
`1.1m` varchar(6) NOT NULL,
`1.2m` varchar(6) NOT NULL,
`1.3m` varchar(6) NOT NULL,
`1.4m` varchar(6) NOT NULL,
`1.5m` varchar(6) NOT NULL,
`1.6m` varchar(6) NOT NULL,
`1.7m` varchar(6) NOT NULL,
`2.m` varchar(6) NOT NULL,
`2.1m` varchar(6) NOT NULL,
`2.2m` varchar(6) NOT NULL,
`2.3m` varchar(6) NOT NULL,
`2.4m` varchar(6) NOT NULL,
`2.5m` varchar(6) NOT NULL,
`2.6m` varchar(6) NOT NULL,
`2.7m` varchar(6) NOT NULL,
`3.m` varchar(6) NOT NULL,
`3.1m` varchar(6) NOT NULL,
`3.2m` varchar(6) NOT NULL,
`3.3m` varchar(6) NOT NULL,
`3.4m` varchar(6) NOT NULL,
`3.5m` varchar(6) NOT NULL,
`hard` varchar(5) NOT NULL,
`firm` varchar(5) NOT NULL,
`good` varchar(5) NOT NULL,
`soft` varchar(5) NOT NULL,
`heavy` varchar(5) NOT NULL,
`dirt` varchar(5) NOT NULL,
PRIMARY KEY (`Key id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `jocky_train`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(20) NOT NULL auto_increment,
`full_name` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`user_name` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
`stable_name` varchar(50) NOT NULL,
`user_pwd` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
`user_email` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
`activation_code` int(10) NOT NULL default '1',
`joined` date NOT NULL default '0000-00-00',
`country` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
`user_activated` int(1) NOT NULL default '1',
`userlevel` tinyint(1) unsigned NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
--
-- Dumping data for table `users`
--
--