<?php

$db=@mysql_connect("mysql.csail.mit.edu","filmsai","filmsAI+3456") or  die("Couldn't connect to server!  Try again in a minute or contact  the webmaster.  ");


@mysql_select_db("filmsAI",$db) or die("Couldn't select database!   Try again in a minute or contact the webmaster.  ");

$fp = fopen("/afs/csail.mit.edu/proj/films/www/data/filenamelist.txt", "r") or die("list was not accessed");
while(!feof($fp))
{
$name=fgets($fp, 4096);
echo $name;
$name=chop($name);
$link="/afs/csail.mit.edu/proj/films/www/data/Podcasts/Submit/".$name.".txt";
$link=sprintf($link);
$fr= fopen($link, "r") or die("file was not accessed");

$podcast=fread($fr,filesize($link));
fclose($fr);
@mysql_query("UPDATE testTJG2 SET podcasts='$podcast'  WHERE url='$name'");

 } 
fclose( $fp );
?>