Please enter some keyword to search'; exit(); } $searchtext = '%'.$searchtext.'%'; } else if($_GET['author'] != '') { $searchtext = '%'.$_GET['author'].'%'; $in = "author"; } else if ($_GET['disp'] == 'all') { $searchtext = "%"; $in = "module"; } else if ($_GET['disp'] != '') { $searchtext = $_GET['disp'].'%'; $in = "module"; } else exit(); $result = searchdb($searchtext, $in, $db); echo ''; if($row = sqlite3_fetch_array($result)) echo ""; else echo '

No results found

'; while($row = sqlite3_fetch_array($result)) { echo ""; } echo '

".$row["module"]."
". "".$row["author"]." : ". $row["title"]. "

'; ?>