1. CREATE TABLE `fixtures` (
 2.  `fix_id` int(10) NOT NULL auto_increment,
 3.  `opp_team` varchar(50) NOT NULL default '',
 4.  `ground` varchar(50) NOT NULL default '',
 5.  `fix_date` date NOT NULL default '0000-00-00',
 6.  `fix_time` varchar(8) NOT NULL default '',
 7.  `home_away` varchar(10) NOT NULL default '',
 8.  `match_type` varchar(40) NOT NULL default '',
 9.  `notes` text NOT NULL,
10.  `closed` char(3) NOT NULL default 'no',
11.  `fix_oldname` varchar(50) NOT NULL default '',
12.  PRIMARY KEY  (`fix_id`)
13. ) TYPE=MyISAM AUTO_INCREMENT=73 ;

CREATE TABLE `news` (
  `news_id` int(10) NOT NULL auto_increment,
  `news_username` varchar(40) default NULL,
  `news` text,
  `news_title` varchar(50) NOT NULL default '',
  `news_date` date NOT NULL default '0000-00-00',
  `topic_image` varchar(20) NOT NULL default 'topic_news.gif',
  `hyperlink_text1` varchar(255) default NULL,
  `hyperlink_url1` varchar(255) default NULL,
  `hyperlink_text2` varchar(255) default NULL,
  `hyperlink_url2` varchar(255) default NULL,
  `news_image` varchar(20) NOT NULL default 'none',
  PRIMARY KEY  (`news_id`)
) TYPE=CREATE TABLE `player_of_match` (
  `pom_id` int(10) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `playername` varchar(50) NOT NULL default '',
  `match_id` int(11) NOT NULL default '0'
  PRIMARY KEY  (`pom_id`)
) ENGINE = MYISAM CHARSET = latin1 AUTO_INCREMENT =160 ;

<?php






interface DB 
{ 
    public function connect(); 
    public function error();
    public function selectdb(); 
    public function close(); 
   
} 
class MySqlDB implements DB 
{
	private  $link; 
        private $server;
        private $username;
        private $password;
        private $dbname;
        
        
        public function connect($server='localhost', $username='cclubs_voetbal', $password='ww2012') 
        { 
            $this->link = mysql_connect($server, $username, $password); 
        } 
        
        public function selectdb($dbname='cclubs_voetbal')
        {
        	$this->link	= mysql_select_db($dbname);
        }
        
        public function error() 
        { 
            return mysql_error($this->link); 
        }
		public function close() 
        { 
            return mysql_close($this->link); 
        } 
}
$MysqlDb	=	new mysqldb();
$MysqlDb->connect('localhost','cclubs_voetbal','ww2012', 'cclubs_voetbal');


// we write this later on, ignore for now.


include('check_login.php');


?>