i am trying to import this into my db, but it always comes up with no db selected.
any idead
-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 24, 2007 at 10:41 PM
-- Server version: 4.1.22
-- PHP Version: 4.4.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `cmhl_hockeystats`
--
-- --------------------------------------------------------
--
-- Table structure for table `announcements`
--
CREATE TABLE `announcements` (
`id` int(7) unsigned zerofill NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`title` mediumtext NOT NULL,
`body` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `announcements`
--
UPDATE `announcements` SET `id` = 0000002, `date` = '2006-08-07', `title` = 'Opeongo Heritage Cup', `body` = 'The Madawaska Valley will host the 2nd Annual Opeongo Heritage Cup from March 30 to April 1, 2007.\r\n\r\nMore details to follow.' WHERE `announcements`.`id` = 0000002;
UPDATE `announcements` SET `id` = 0000003, `date` = '2006-09-13', `title` = 'Looking for Teams', `body` = 'Looking for teams for future championships:\r\n\r\n* Vietnamese\r\n* Latvian (Baltic)\r\n* Hispanic\r\n* Scandinavian\r\n\r\n Please contact info@cmhl.ca for details' WHERE `announcements`.`id` = 0000003;
UPDATE `announcements` SET `id` = 0000004, `date` = '2006-08-10', `title` = 'The Heritage Bowl Finals', `body` = 'The Winner of the Canadian Multicultural Hockey Championships in December will represent Toronto in an All-Ontario Final against the winner of the Opeongo Heritaage Cup in Barry\\''s Bay.' WHERE `announcements`.`id` = 0000004;
