Hi everyone. I need your help. After searching it will display like a dictionary. For example
2 Records contain words:
1) Movie, Natur, Cinema, Action, Title
2)Cinema, Comedy, Titel, Natur
I search after for example: "Comedy" and then the searching will seperate by "," and display:
C
Cinema
Comedy
N
Natur
T
Titel
And then I click on Cinema or Comedy or Natur or Titel that will link the same target (more details). Hope you understand what i mean. Look at this link http://kg.out-force.com/sok_ordlist.php for more understandable.(Søk = Search) Thanks for help.
<?php
include("dbconnect.php");
$search=$_POST["sok_ordliste"];
if(!$search)
{
echo("Task inn ett søk. <a href='sok.php'>Prøv igjen</a>");
}
else
{
$result=mysql_query("SELECT *FROM media WHERE Sokord LIKE '%$search%' ORDER BY Sokord");
$letter_first= '';
if(mysql_num_rows($result) <= 0)
{
echo (mysql_num_rows($result))." Treff. <a href='sok.php'>Prøv igjen</a><br> ";
}
else
{
echo (mysql_num_rows($result))." Treff<br>";
}
while($r=mysql_fetch_assoc($result))
{
if(strtoupper(substr($r['Sokord'],0,1))!= $letter_first)
{
$letter_first= strtoupper(substr($r['Sokord'],0,1));
echo '<b>'.$letter_first.'</b><br>';
}
$Sokord=$r["Sokord"];
echo "<a href='sok_ordlist_list.php?ordliste=$Sokord'>[ $Sokord ] </a><br><br>";
}
unset($letter_first);
}
?>
<?php
include"dbconnect.php";
if($_SESSION['brukernavn']=true)
$sok=$_GET["ordliste"];
$result=mysql_query("SELECT *FROM media WHERE Sokord = '$sok'");
while($r=mysql_fetch_array($result))
{
$Tittel=$r["Tittel"];
$Medium=$r["Medium"];
$Sjanger=$r["Sjanger"];
$Produsent=$r["Produsent"];
$Publisert=$r["Publisert"];
$Starttid=$r["Starttid"];
$Varighet=$r["Varighet"];
$Rettighetshaver=$r["Rettighetshaver"];
$Fag=$r["Fag"];
$Trinn=$r["Trinn"];
$Tale=$r["Tale"];
$Teksting=$r["Teksting"];
$Adresse=$r["Adresse"];
$Identitetsnr=$r["Identitetsnr"];
echo "<b>Tittel:</b> $Tittel<br><b>Medium:</b>$Medium<br><b>Sjanger:</b>$Sjanger<br> <b>Produsent:</b>$Produsent<br>";
echo"<b>Publisert:</b>$Publisert<br><b>Starttid:</b>$Starttid<br><b>Variget:</b>$Varighet<br><b>Rettighetshaver:</b>$Rettighetshaver<br>";
echo "<b>Fag:</b>$Fag<br><b>Trinn:</b>$Trinn<br><b>Tale:</b>$Tale <br><b>Teksting:</b>$Teksting <br><b>Adresse:</b>$Adresse<br>";
echo "<b>Identitetsnr:</b>$Identitetsnr<br>";
}
mysql_query($result);
?>
