include('inc/functions.php'); function displayResults() { if (isset($_GET['mag_release_type'])) { /*select stories of a specified magazine type*/ if ($_GET['mag_release_type'] == "The Kroger Roth Report") {$and_clause = "AND release.releaseTypeID='1' AND release.releaseType_mag =\"".mysql_escape_string($_GET['mag_release_type'])."\"";} else {$and_clause = "AND release.releaseTypeID='3' AND release.releaseType_mag =\"".mysql_escape_string($_GET['mag_release_type'])."\"";} } else if (isset($_GET['sportID'])) { /*select stories about a specified sport*/ $and_clause = "AND release.releaseTypeID='3' AND sport.sportID ='".mysql_escape_string($_GET['sportID'])."'"; } else if (isset($_GET['authorID'])) { /*select stories written by a specified author*/ $and_clause = "AND release.releaseTypeID='3' AND author.authorID ='".mysql_escape_string($_GET['authorID'])."'"; } else if (isset($_GET['volumeID'])) { /*select stories written by a specified author*/ $and_clause = "AND release.releaseTypeID='3' AND issue.volumeNumID ='".mysql_escape_string($_GET['volumeID'])."'"; } $select_stories = "SELECT DISTINCT release.releaseID, release.title, issue.volumeNumID, issue.issueNumID, release.content, sport.sport, sport_release_list.url, release.releaseType_mag, author.name FROM ((`author` RIGHT JOIN `release` ON author.authorID = release.authorID) LEFT JOIN `issue` ON release.issueID = issue.issueID) LEFT JOIN sport_release_list ON sport_release_list.releaseID = release.releaseID LEFT JOIN sport ON sport_release_list.sportID = sport.sportID WHERE release.isPosted = '1' ". $and_clause . " GROUP BY release.releaseID ORDER BY release.releaseID DESC "; //echo $select_stories; /*add orderby functions in here later*/ /*add search form in here later*/ $stories_result = mysql_query($select_stories); $num_stories = mysql_num_rows($stories_result); /*display results*/ if($num_stories >=1) { echo "
".$content."
"; echo "