I've written my first search script and I have 2 problems. First, I'm
getting duplicate results because I have identical questions related
to different topic_id's (aka categories). Second, if a search term
isn't found, it's
not displaying the "No search results" text on the last line. Any help
would be greatly appreciated.
<?php
$searchTerms = $_POST['search_term']; $searchSection =
$_POST['search_type'];
if($searchSection == 1) {
require_once 'db_connector.php';
$connector = new DB_Connector();
$result = $connector -> query("SELECT * FROM 1_questions WHERE
question LIKE '%$searchTerms%'");
echo '<span class="title">Search Results</span>';
echo '<div class="title_rule"></div>';
while($row = $connector -> fetchArray($result)) {
echo '<div class="question">'.$row['question'].'</div>';
echo nl2br('<div class="answer">'.$row['answer'].'</div>');
echo '
';
} }
elseif($searchSection == 2) {
require_once 'db_connector.php';
$connector = new DB_Connector();
$result = $connector -> query("SELECT * FROM 2_questions WHERE
question LIKE '%$searchTerms%'");
echo '<span class="title">Search Results</span>';
echo '<div class="title_rule"></div>';
while($row = $connector -> fetchArray($result)) {
echo '<div class="question">'.$row['question'].'</div>';
echo nl2br('<div class="answer">'.$row['answer'].'</div>');
echo '
';
} }
else{
exit('<span class="title">Search Results</span><div
class="title_rule"></div><div class="question">No search resluts
found.</div>'); }
?>
