Søge ting virker ikke Hjælp mig
Jeg ved ikke hvad jeg har fådet lavet af lort, men det virker ikke mere som det skal.Når jeg søger efter nådet kommer der bare en tom side frem.
Det er ikke så fedt
>><><>>>>><<><>>>>>>>><<>>>>
koden:
<?
include ("include/kontakt_Db.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>DVD Kartotek</title>
<STYLE type="text/css">
<!--
BODY {
scrollbar-face-color: #ffffff;
scrollbar-highlight-color: #444357;
scrollbar-3dlight-color: #444357;
scrollbar-darkshadow-color: #444357;
scrollbar-shadow-color: #444357;
scrollbar-arrow-color: #444357;
scrollbar-track-color: #444357;
}
-->
</style>
</head>
<Center>
<body bgcolor="#444357" topmargin="0" marginheight="0" leftmargin="0" text="#ffffff" link="#FFFFFF" alink="#FFFFFF" vlink="#FFFFFF">
<form action="seek_data.php" method="post">
<input class="input" type="text" name="seek" value="Søg" onfocus="if(this.value=='Søg')this.value='';"
onblur="if(this.value=='')this.value='Søg';" size="20">
<select name='kat' size='1'>
<option value='alle' selected>Søg på alt</option>
<option value='nr'>DVD Nummer</option>
<option value='titel'>Titel</option>
<option value='titel2'>Undertiteler</option>
<option value='gener'>Gener</option>
<option value='udlaandt'>Udlånt</option>
</select>
<input type="submit" class="input" name="sog" value="Søg">
</form>
<?
if($_POST[kat] =="alle"){
$color2 = "#444357";
$color1 = "#444357";
//con_db();
include ("include/kontakt_Db.php");
$result = mysql_query("select * from dvdfilm where titel like '$_POST[seek]%' or titel2 like '$_POST[seek]%' or nr like '$_POST[seek]%' or skuespiller_1 like '$_POST[seek]%' or skuespiller_2 like '$_POST[seek]%' or skuespiller_3 like '$_POST[seek]%' or skuespiller_4 like '$_POST[seek]%' or skuespiller_5 like '$_POST[seek]%' or skuespiller_6 like '$_POST[seek]%' or skuespiller_7 like '$_POST[seek]%' or skuespiller_8 like '$_POST[seek]%' or skuespiller_9 like '$_POST[seek]%' or skuespiller_10 like '$_POST[seek]%' or gener like '$_POST[seek]%' or udlaandt like '$_POST[seek]%' or id like '$_POST[seek]%' ORDER BY titel") or die(mysql_error());
$nr = mysql_num_rows($result);
print "Din søgning på: <b>$_POST[seek]</b> gav $nr resultater";
if ($nr > 0) {
while ($row = mysql_fetch_array($result)){
$color = ($color == $color1 ? $color2 : $color1);
echo"
<table border='0' width='300' cellspacing='0' cellpadding='0' bgcolor='$color'>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Titel</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>
<a href=index2.php?film_id=$row[id]/" target=\"I1\">$row[titel]</a></font></td>
</tr>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Undertitele</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>
<a href=index2.php?film_id=$row[id]/" target=\"I1\">$row[titel2]</a></font></td>
</tr>
<table border='0' width='300' cellspacing='0' cellpadding='0' bgcolor='$color'>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Gener</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>$row[gener]</font></td>
</tr>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Udlånt til</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>$row[udlaandt_til]</font></td>
</tr>
</table><br>
";
}
}
}
elseif ($_POST[kat] !="alle" and !empty($_POST[kat])){
$color2 = "#6699cc";
$color1 = "#6699cc";
//con_db();
include ("include/kontakt_Db.php");
$result = mysql_query("select * from dvdfilm where $_POST[kat] like '$_POST[seek]%' ORDER BY titel") or die(mysql_error());
$nr = mysql_num_rows($result);
print "Din søgning på: <b>$_POST[seek]</b> gav $nr resultater";
if ($nr > 0) {
while ($row = mysql_fetch_array($result)){
$color = ($color == $color1 ? $color2 : $color1);
echo"<p>";
echo"
<table border='0' width='300' cellspacing='0' cellpadding='0' bgcolor='$color'>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Titel</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>
<a href=index2.php?film_id=$row[id]/" target=\"I1\">$row[titel]</a></font></td>
</tr>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Undertitele</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>
<a href=index2.php?film_id=$row[id]/" target=\"I1\">$row[titel2]</a></font></td>
</tr>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Gener</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>$row[gener]</font></td>
</tr>
<tr>
<td width='130' valign='top'><font size='1' face='Verdana'>Udlånt</font></td>
<td width='5' valign='top'><font size='1' face='Verdana'>:</font></td>
<td width='200' valign='top'><font size='1' face='Verdana'>$row[udlaandt]</font></td>
</tr>
</table><br>
";
}
}
}
?>
</Center>
</body>
</html>
LINK TIL FILEN= www.dvdfilm.frac.dk/seek_data.php
