<?php

@mysql_connect("mysql.csail.mit.edu","filmsai","filmsAI+3456") or die("Foo!");
@mysql_select_db("filmsAI") or die("Bar!");

	echo ('



	<p><table><tr><td width=5%></td><td>

	<table style="text-align: left; width: 100%;" border="0" cellpadding="0" cellspacing="3">
		<tbody>
		');

//echo('one');
//$films= @mysql_query("SELECT * FROM `testTJG2` WHERE (url != NULL;)") or die('help!');
//echo('<br>2 '.$films);
//$numfilms=count($films);
//echo('<br>3 '.$numfilms);

$numfilms=95;

echo('<p>There are <b>'.$numfilms.'</b> films currently in the database.
<p><font size=2> Quick Jump:  
	<a href="#10">10</a> 
	<a href="#20">20</a> 
	<a href="#30">30</a> 
	<a href="#40">40</a> 
	<a href="#50">50</a> 
	<a href="#60">60</a> 
	<a href="#70">70</a> 
	<a href="#80">80</a>
	<a href="#90">90</a></font>
');


$reel=0;

while ($reel < 110) {
	$reel++;
	$select= "SELECT * FROM `testTJG2` WHERE (reel=$reel)"; 
        $result=@mysql_query($select) or die('The search on '.$reel.' failed; please try again in a minute or contact the webmaster.');	


	
	$current = mysql_fetch_array($result);
	$title = $current["title"];
	$date = $current["date"];
	$description = $current["description"];
	$desc = substr($description,0,80);
	$filename = $current["url"];
	$tempname = split("-", $filename);
	$firstbit = $tempname[0];
	$firstchar = substr_replace($firstbit, "", -1);
	$firstchar++;
	$mod=$reel%10;



if($filename){			


	echo('
				<tr><td>
	');
        
//	echo($mod);
//	if(empty($mod)){
//		echo('<a name="'.$reel.'"></a>me!');
//	}
	
	echo ('				
					<a href="http://projects.csail.mit.edu/films/dynamicPage.php?reel%23='.$firstbit.'&amp;res='.$list.'">'.$filename.'</a>
					<b>'.$title.'</b> : '.$date.'<br>

					'.$desc.'...
					</td></tr>
				
');

}
}

echo('
		</tbody>
	</table>
	</td></tr></table>
	');

?>
