DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
  `videoID` mediumint(8) unsigned NOT NULL auto_increment,
  `status` enum('Active','Disabled') NOT NULL default 'Active',
  `title` varchar(35) default NULL,
  `caption` text,
  `category` varchar(35) default NULL,
  `filename` varchar(35) default NULL,
  `embed_code` text,
  `video_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`videoID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `videos`
-- 

INSERT INTO `videos` (`videoID`, `status`, `title`, `caption`, `category`, `filename`, `embed_code`, `video_date`) VALUES (1, 'Active', 'Lonely Angel', 'Kid Theodore''s Lonely Angel music video', 'www.kidtheodore.com', NULL, '<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/l5os6oII8Hk"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/l5os6oII8Hk" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object>', '2007-10-25')

function getVideo($vid) {
//$vid = a videoID in the table videos
	$query = "SELECT * FROM videos WHERE status = 'Active' AND videoID = '$vid'"; 
	$result = mysql_query($query); 
  	  if (mysql_num_rows($result) > 0) {		
		$row = mysql_fetch_array( $result );
			$output .= "
			<h2>$row[title]</h2>
			$row[embed_code]<br>
			$row[caption]
			";
	  } else {
	  $output = "No video was found at this time.<br> Please check back soon.<br>";
	  }

			
return $output;
} //usage //echo getVideo($vid);