Go back and try again. '); } elseif((!$_GET['subject']) && (!$_GET['title']) && (!$_GET['description']) && (!$_GET['comments']) && (!$_GET['notes']) && (!$_GET['people'])) { die('You chose no fields within which to search! Go back and try again. '); } else { $term=$_GET['term']; $search = array('title' => $_GET['title'], 'subject' => $_GET['subject'], 'people' => $_GET['people'], 'description' => $_GET['description'], 'notes' => $_GET['notes']); $commentsearch = $_GET['comments']; } $db=@mysql_connect("mysql.csail.mit.edu","filmsai","filmsAI+3456") or die("Foo!"); @mysql_select_db("filmsAI",$db) or die("Bar!"); $added = array(); $foo = array(); foreach ($search as $sea => $value) { if ($value == 'on') { $try=@mysql_query("SELECT * FROM `testTJG2` WHERE MATCH ($sea) AGAINST ('$term')",$db) or die('The search on '.$sea.' failed; please try again in a minute or contact the webmaster.'); for ($i = 0; $i <= mysql_num_rows($try); $i++) { $temp = @mysql_fetch_array($try); if ($temp['reel']) { if (!in_array($temp['reel'], $added)) { array_push($foo, $temp); array_push($added, $temp['reel']); } } } } } $list = ''; foreach ($foo as $bar) { $list = $list.$bar["reel"].":"; } $list = substr($list, 0, -1); foreach ($foo as $current) { $number = $current["reel"]; $title = $current["title"]; $date = $current["date"]; $description = $current["description"]; $desc = substr($description,0,80); $filename = $current["url"]; $firstnum = $filename{0} + 1; $firstbitarray = split('-', $filename); $firstbit = $firstbitarray[0]; $firstchar = (string) $firstnum; echo ('

'.$title.' - '.$date.' '.$desc.' . . . Check it out!

'); echo "
\n
\n"; } if ($commentsearch == 'on') { @mysql_query("SELECT * FROM `comments` WHERE (`filename` = $filmnumber)",$dbcnt); } //POST METHOD CODE //

// // //

?>