School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become an Expert!

Join 300,370 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,458 people online right now. Registration is fast and FREE... Join Now!




Linking Tables

 

Linking Tables, Linking Tables

peter yianni

18 Jun, 2009 - 01:56 PM
Post #1

D.I.C Regular
***

Joined: 4 Jun, 2009
Posts: 308



Thanked: 2 times
My Contributions
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`
--

--





User is offlineProfile CardPM
+Quote Post


Robin Marsh

RE: Linking Tables

20 Jun, 2009 - 05:29 AM
Post #2

New D.I.C Head
*

Joined: 7 May, 2009
Posts: 13



Thanked: 1 times
My Contributions
You have not normalised these tables as you have repetitious data in multiple tables.

I.E.
Tables `horse_g_dirt` and `horse_g_good` are identical; you need to get all the tables that hold the same data into a single table and if need be create an additional joined table to hold the 'going' data.

This post has been edited by Robin Marsh: 20 Jun, 2009 - 05:30 AM
User is offlineProfile CardPM
+Quote Post

CamoDeveloper

RE: Linking Tables

20 Jun, 2009 - 05:44 AM
Post #3

D.I.C Head
Group Icon

Joined: 12 Jun, 2009
Posts: 204



Thanked: 12 times
Dream Kudos: 200
My Contributions
I posted this in your other thread, did you try this?
QUOTE(CamoDeveloper @ 17 Jun, 2009 - 08:29 PM) *

With that statement you're telling the database to return those values from all the tables separately. You need to join them together using the stable_name column. You may need to adjust this a little depending on the results you get. This is what it should look like :
CODE

-- I usually add styling to my statements for easier reading
SELECT
    *
FROM
    -- I made users the primary table, but you could make any of these the primary
    users
    -- I'm joining them on the common column name stable_name. To join tables they need to have a column that both tables use so the database can use it as a checking point
    LEFT JOIN horse_stats ON users.stable_name = horse_stats.stable_name
    LEFT JOIN jocky_stats ON users.stable_name = jocky_stats.stable_name
    -- You might need to change LEFT to either RIGHT or INNER depending on the results you recieve. LEFT should work just fine
WHERE
    -- Only selects the data that matches
    users.stable_name = horse_stats.stable_name
    AND users.stable_name = jocky_stats.stable_name
-- The entire WHERE can be removed if you want, it just helps with grabbing certain data


Let me know if you get any errors or have any more questions.

~Camo

User is offlineProfile CardPM
+Quote Post

peter yianni

RE: Linking Tables

20 Jun, 2009 - 02:51 PM
Post #4

D.I.C Regular
***

Joined: 4 Jun, 2009
Posts: 308



Thanked: 2 times
My Contributions
QUOTE(CamoDeveloper @ 20 Jun, 2009 - 05:44 AM) *

I posted this in your other thread, did you try this?
QUOTE(CamoDeveloper @ 17 Jun, 2009 - 08:29 PM) *

With that statement you're telling the database to return those values from all the tables separately. You need to join them together using the stable_name column. You may need to adjust this a little depending on the results you get. This is what it should look like :
CODE

-- I usually add styling to my statements for easier reading
SELECT
    *
FROM
    -- I made users the primary table, but you could make any of these the primary
    users
    -- I'm joining them on the common column name stable_name. To join tables they need to have a column that both tables use so the database can use it as a checking point
    LEFT JOIN horse_stats ON users.stable_name = horse_stats.stable_name
    LEFT JOIN jocky_stats ON users.stable_name = jocky_stats.stable_name
    -- You might need to change LEFT to either RIGHT or INNER depending on the results you recieve. LEFT should work just fine
WHERE
    -- Only selects the data that matches
    users.stable_name = horse_stats.stable_name
    AND users.stable_name = jocky_stats.stable_name
-- The entire WHERE can be removed if you want, it just helps with grabbing certain data


Let me know if you get any errors or have any more questions.

~Camo



YES M8
triyed it did not work i will send u messege
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/7/09 09:10PM

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month