back to the main page (sorry about that) and give it another shot. ');
if ($GET['newest'])
$newest = $_GET['newest'];
$db = @mysql_connect("mysql.csail.mit.edu", "filmsai", "filmsAI+3456")
or die('Error! The script couldn\'t connect to the server. Please try again in a minute or contact the webmaster. ');
@mysql_select_db("filmsAI",$db)
or die('Error! The script encountered a database error. Please try again in a minute or contact the webmaster. ');
$filename = str_replace("/", "", $filename);
$number = substr($filename, 0, 2);
echo (''.$title.'
');
$query = @mysql_query("SELECT * FROM comments WHERE filename='$filename'") or die("The script encountered an unknown error! Try again in a minute or contact the webmaster.");
$size = @mysql_num_rows($query);
$title = str_replace(" ", "%20", $title);
if ($size == 0) {
echo ('
Nobody has entered any comments yet! Why don\'t you tell us what you think?
You can also go back to the film\'s page.');
}
else {
echo ('
');
echo ("\n");
echo ('
');
if ($newest == 'newest') {
for ($j = $size; $j > 0; $j--) {
$result = @mysql_fetch_array($query);
$date = $result['date'];
$name = $result['name'];
$comment = $result['comment'];
echo ('
At '.$date.' '.$name.' wrote:
'.$comment.'
|
');
}
}
else {
for ($k = 0; $k < $size; $k++) {
$parray[$k] = @mysql_fetch_array($query);
}
for ($m = $size - 1; $m >= 0; $m--) {
$result = $parray[$m];
$date = $result['date'];
$name = $result['name'];
$comment = $result['comment'];
echo ('
At '.$date.' '.$name.' wrote:
'.$comment.'
|
');
}
}
}
$title = str_replace(" ","%20", $title);
echo ('
|
Submit your own comments!
|
');
?>