Mit søgeresultater giver fire af hver resultat
HejHåber i kan hjælpe.
Jeg har lavet en søgeformular, som giver et lidt for stort output. Den vælger de rigtige biler, men viser hver bil 4 gange.....
Hvad er det der går galt?
-------------------------
<HTML>
<HEAD>
<TITLE>Dan Søndergaard Automobiler</TITLE>
<link rel="stylesheet" type="text/css" href="style.css">
</HEAD>
<BODY bgcolor="#FFFFFF">
<center>
<table cellspacing="0" cellpadding="0" width="800" height="500">
<tr valign="top" align="center">
<td>
<table cellspacing="0" cellpadding="0" width="800" height="100">
<tr valign="top" align="center">
<td background="top.jpg"><?
include "tilbage.php"
?>
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="800" height="1">
<tr>
<td background="linie.jpg">
<table cellspacing="0" cellpadding="0" width="800" height="338">
<tr>
<td width="200" valign="top">
<table cellspacing="0" cellpadding="0" width="200" height="265">
<tr valign="top" align="left">
<td width="200" height="265" valign="top" align="left" background="venstre.jpg">
<?
include "menu.php"
?>
</td>
</tr>
<tr valign="top" align="left">
<td></td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="200" height="73">
<tr valign="top" align="left">
<td width="200" height="73" valign="top" align="left"></td>
</tr>
<tr valign="top" align="left">
<td></td>
</tr>
</table>
</td>
<td width="600" valign="top">
<br>
<center><h3><b>Her er resultaterne af din søgning:</b></h3>
<table cellspacing="0" cellpadding="5" width="570">
<tr>
<td><b>Nummer</b></td>
<td><b>Mærke</b></td>
<td><b>Model</b></td>
<td><b>Type</b></td>
<td><b>Motor</b></td>
<td><b><div align="right">Pris</div></b></td>
<td><b><div align="right">Km</div></b></td>
</tr>
<tr>
<TD colspan="8"><HR width="570%">
</td>
</tr>
<?
if($_GET['up'] == "ja"){
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$where=array();
if($_POST['maerke']!='1')
{
$where[]="bil_bil.maerke='".$_POST['maerke']."'";
}
if($_POST['model']!='1')
{
$where[]="bil_bil.model='".$_POST['model']."'";
}
if ($_POST[prisvalg] != '1')
{
$where[] = "bil_pris.id = '" . $_POST[prisvalg] . "'";
}
if ($_POST[kmvalg] != '1')
{
$where[] = "bil_km.id = '" . $_POST[kmvalg] . "'";
}
$foresp = mysql_query("
SELECT bil_bil.km, bil_bil.pris, bil_bil.id, bil_bil.maerke, bil_bil.model, bil_bil.type, bil_bil.variant, bil_model.model AS model1, bil_maerke.maerke AS maerke1, bil_type.type AS type1, bil_variant.variant AS variant1
FROM bil_bil
LEFT JOIN bil_maerke ON bil_maerke.id = bil_bil.maerke
LEFT JOIN bil_model ON bil_model.id = bil_bil.model
LEFT JOIN bil_type ON bil_type.id = bil_bil.type
LEFT JOIN bil_variant ON bil_variant.id = bil_bil.variant
INNER JOIN bil_pris ON (bil_pris.low IS NULL OR bil_bil.pris >= bil_pris.low) AND (bil_pris.high IS NULL OR bil_bil.pris <= bil_pris.high)
INNER JOIN bil_km ON (bil_km.low IS NULL OR bil_bil.km >= bil_km.low) AND (bil_km.high IS NULL OR bil_bil.km <= bil_km.high)
".(count($where)?"WHERE ".implode(" AND ",$where):"")."
ORDER BY bil_bil.id desc
");
$RowNo = 0;
while ($data = mysql_fetch_array($foresp))
{
$RowNo++;
$bgColor = ($RowNo % 2 == 0) ? "#e6e6e6" : "white";
echo "<tr style='background-color: $bgColor'><td><a href='visbil.php?id=".$data['id']."'>".$data['id']."</a></td><td><div align='left'><a href='visbil.php?id=".$data['id']."'>".$data['maerke1']."</a></td><td><a href='visbil.php?id=".$data['id']."'>".$data['model1']."</a></td><td><a href='visbil.php?id=".$data['id']."'>".$data['type1']."</a></td><td><a href='visbil.php?id=".$data['id']."'>".$data['variant1']."</a></td><td><a href='visbil.php?id=".$data['id']."'><div align='right'>".$data['km']." km</div></a></td><td><a href='visbil.php?id=".$data['id']."'><div align='right'>".$data['pris']." kr.</div></a></div></td></tr>";
}
}
?>
</tr>
</table>
<br></center>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="800" height="62">
<tr>
<td background="bund.jpg"></td>
</tr>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>
