MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 sec)
Code: Select all
CREATE TABLE `surf_reports` (
`surf_report_date` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_type` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_surface` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_form` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_wave_size` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_comments` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`surf_report_id` smallint(6) NOT NULL AUTO_INCREMENT,
`imgdata` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`imgone` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`imgtwo` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`imgthree` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`imgfour` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`title` text character SET utf8 collate utf8_unicode_ci NOT NULL,
`user` text character SET utf8 collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`surf_report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
--
-- Dumping data for table `surf_reports`
--
INSERT INTO `surf_reports` (`surf_report_date`, `surf_report_type`, `surf_report_surface`, `surf_report_form`, `surf_report_wave_size`, `surf_report_comments`, `surf_report_id`, `imgdata`, `imgone`, `imgtwo`, `imgthree`, `imgfour`, `title`, `user`) VALUES
('2008-05-21', 'First', 'Semi Choppy', 'Poor to Fair', '1.1 Surf is waist high on sets. Looks knee high from the beach; brownish water and so so WSW winds.', 'New skim DVD''S, special order you KG Fish Today, from at once inventory sheet.', 18, '310w232.5hCK2Soka001.JPG', '', '', '', '', '', '70.183.227.110'),
('2008-06-05', 'First', 'semi choppy', 'POOR TO FAIR', '0.7 Surf is a hair bigger today, around knee high, with onshore winds, the models show a small increase starting on Friday thru the weekend', 'STEWART EPOXY AND POLY FUNBOARDS and LONGBOARDS--SUPER HOT *schools out for summer!!!!!!!!!!!!!!!!!!!', 31, '', '', '', '', '', '', '68.225.122.213'),
('2008-06-06', 'FIRST', 'semi choppy', 'fair', '0.8 Surf looks to be thigh to waist high with ESE winds on already this morning, looks OK but a few reports of jellies and some seaweed showing up', 'SCHOOLS OUT FOR SUMMER!!!!!!!!!!!!!!!!!', 32, '', '', '', '', '', '', '68.225.122.213'),
('', 'Test', '', '', '', '', 33, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 34, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 35, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 36, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 37, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 38, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 39, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 40, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 41, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 42, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 43, '', '', '', '', '', '', ''),
('', 'Test', '', '', '', '', 44, '', '', '', '', '', '', '');
Thank you very much for helping me. I really do appreciate it.