= " . Ktozero($grade) . " ) "; $narrow = ""; } else { $grade_query = ""; $narrow = "
Narrow Your Search:

Narrow your search by grade:
"; } $query = "SELECT * FROM gotham_guide WHERE MATCH (organization,intro,keywords,programs,inschool,materials,development,events,resources) AGAINST ('" . $q . "') " . $grade_query . ""; } if (isset($_GET['word']) && isset($_GET['grade'])) { $word = $_GET['word']; $grade = $_GET['grade']; $narrow = ""; $query = "SELECT ID, organization, keywords, min_grade, max_grade, REPLACE(REPLACE(organization, 'The ', ''), 'El ', '') AS new_organization FROM gotham_guide WHERE keywords LIKE '%".pg_escape_string(urldecode($word))."%' AND ( min_grade <= " . Ktozero($grade) . " AND max_grade >= " . Ktozero($grade) . " ) ORDER BY new_organization"; } else if (isset($_GET['word']) && !isset($_GET['grade'])) { $word = $_GET['word']; $narrow = "
Narrow Your Search:

Narrow your search by grade:
"; $query = "SELECT ID, organization, keywords, min_grade, max_grade, REPLACE(REPLACE(organization, 'The ', ''), 'El ', '') AS new_organization FROM gotham_guide WHERE keywords LIKE '%".pg_escape_string(urldecode($word))."%' ORDER BY new_organization"; } else if (!isset($_GET['q']) && !isset($_GET['word']) && isset($_GET['grade'])) { $grade = $_GET['grade']; $narrow = "
Narrow Your Search:

To narrow your search by subject, click here.

Or,
"; $query = "SELECT ID, organization, min_grade, max_grade, REPLACE(REPLACE(organization, 'The ', ''), 'El ', '') AS new_organization FROM gotham_guide WHERE ( min_grade <= " . Ktozero($grade) . " AND max_grade >= " . Ktozero($grade) . " ) ORDER BY new_organization"; } $result = queryDB($query); if (mysql_num_rows($result) == 1) { $row = mysql_fetch_object($result); header("Location: detail.php?id=$row->ID"); } else { ?> Gothamed.org > GothamED Directory: NYC History Programs and Services for Teachers and Students K-12
GothamED Directory - Search
"; if (isset($word)) { echo "Subject: ".$word; } if (isset($word) && isset($grade)) { echo "
"; } if (isset($q)) { echo "Keyword: ".$q; } if (isset($q) && isset($grade)) { echo "
"; } if (isset($grade)) { echo "Grade: ".zerotoK($grade); } echo "

"; if (mysql_num_rows($result) > 0) { while($row = mysql_fetch_object($result)) { echo "

ID ."\">" . $row->organization . " (Grades " . zerotoK($row->min_grade) . " - " . zerotoK($row->max_grade) . ")

"; } } else { echo "

Sorry, there are no results that match your search criteria.

"; } ?>