What' s wrong with search fulltext?

ngu_tri

Hello everyone. I try to search and display a exactly word, for example: I am interested to search after "Database", so it should display ONLY "Database". NOT DISPLAYS LIKE THIS: Database, Data, Datasheet, Database oracle.....

My php coding did not display anything.

Hope you can help me. Thanks

<?php
include("dbconnect.php");
$search=$_POST["sok_emne"];

if(!$search)
{

     echo("New search. <a href='sok_emne_link.php'>Try again</a>");
 }
 else
 {
     $result=mysql_query("SELECT *FROM media WHERE Innhold REGEXP '(^|\s)$search($|\s)'");
     if(mysql_num_rows($result) <= 0)
     {
        echo (mysql_num_rows($result))." No match. <a href='sok_emne_link.php'>Prøv igjen</a><br> ";
     }
     else
     {
         echo (mysql_num_rows($result))." Match/Matches.<br>";
     }
     while($r=mysql_fetch_array($result))
     {
      $Innhold=$r["Innhold"];
      echo "<a href='sok_emne_list.php?emne=$Innhold'>[ $Innhold ]  </a><br>";
     }
  }

tsinka

Hi,

try something like

 $result=mysql_query("SELECT *FROM media WHERE Innhold REGEXP '(^| )$search(\$| )'");

Thomas

ngu_tri

Thanks for response. But it did not work either. I also tried this
'\s+$search\s+'. Not work. Anyone has better idea?? Thanks

tsinka

There's an error in my query ...

Replace

SELECT FROM
by
SELECT FROM

Thomas

ngu_tri

It did not work either Thomas. Do you have any better ideas? Thanks

tsinka

The query worked when I tested it (but might not work with special search words).

To check if the query works at all do something like this:

$result=mysql_query("SELECT * FROM media WHERE Innhold REGEXP '(^| )$search(\$| )'") or die("SQL error: ".mysql_error());

EDIT: Additionally add
error_reporting(E_ALL);
on top of the script.

Thomas

ngu_tri

I searched "Nature", then it displays all records that contains "Nature": (The same as LIKE '%$search%')

[ Nature of Australia: 1. Portrett av et øykontinent ]
[ Nature of Australia: 2. Under Steibukkens vendekrets ]
[ Nature of Australia: 3. Regnskogene ]
[ Nature of Australia: 4. Ørken ]
[ Nature of Australia: 5. Urbefolkning og natur ]
[ Nature of Australia: 6. Gammel natur vs. Moderne tider ]
[ Nature of Australia: 4. Ørken ]
[ Nature of Australia: 5. Urbefolkning og natur ]

[ Nature of Australia: 6. Gammel natur vs. Moderne tider ]

It is not working either. And it did not show any errors.

Do you have any good ideas??? Thanks