|
|
Posted by Captain Paralytic on 08/28/07 09:35
On 28 Aug, 00:54, mbarbs <mbarbs.m...@gmail.com> wrote:
> 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 '<br />';
>
> } }
>
> 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 '<br />';
>
> } }
>
> else{
>
> exit('<span class="title">Search Results</span><div
> class="title_rule"></div><div class="question">No search resluts
> found.</div>'); }
>
> ?>
The way I read it, the "No search resluts (SIC) found" text is
triggered by the posted input value of search_type being something
other than 1 or 2. It has nothing to do with finding anything in the
searches themselves.
Navigation:
[Reply to this message]
|