|
|
Posted by Tom on 08/28/07 17:34
On Tue, 28 Aug 2007 02:35:08 -0700, Captain Paralytic wrote...
>
>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.
>
Depending which Database you are using, such as MySQL or PostreSQL, there's
usually some PHP functions you can find at http://www.php.net, that would help
you get a count on your query results. As an example PosgreSQL would use the
"pg_num_rows()" function whereas MySQL would usually use "mysql_num_rows()".
Tom
--
NewsGuy Takes Usenet Cellular!
Download newsgroup MP3's to your Cell or PDA
Free Trial - http://newsguy.com/cellphone.htm
Navigation:
[Reply to this message]
|