Hvordan ordner jeg prisintervaller i søgefunktion!
Nedenstående er min søge formular.Jeg har (med lidt hjælp!) fået den til at virke med mærke, model og type.
Nu er mit problem at jeg har en pris på bilen.
Jeg kunne godt tænke mig at lave en søgning på prisen i intervaller. Hvordan arbejder jeg det ind i denne søgning?
$pris står i tabellen bil_bil
----------------------
<link rel="stylesheet" type="text/css" href="style.css">
<?
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['type']!='1')
{
$where[]="bil_bil.type='".$_POST['type']."'";
}
$foresp = mysql_query("
SELECT bil_bil.id, bil_bil.maerke, bil_bil.model, bil_bil.type, bil_maerke.maerke as maerke1
FROM bil_bil
LEFT JOIN bil_maerke ON bil_maerke.id = bil_bil.maerke
".(count($where)?"WHERE ".implode(" AND ",$where):"")."
ORDER BY bil_bil.maerke desc
");
while($data = mysql_fetch_array($foresp)) {
echo $data['maerke1'];
}
}else{
?>
<h5><b><font size=4>Søg</font></b><p>
<FORM METHOD=POST ACTION='soeg1.php?action=soeg&up=ja'>
<table>
<tr>
<td><p>Bilmærke:</p></td>
<td><select name="maerke">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT maerke, id FROM bil_maerke ORDER BY id");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select></td>
</tr>
<tr>
<td><p>Bilmodel:</p></td>
<td><select name="model">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT model, id FROM bil_model ORDER BY id");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select></td>
</tr>
<tr>
<td><p>Type af bilmodel:</p></td>
<td><select name="type">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT type, id FROM bil_type ORDER BY id");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select></td>
</tr>
<tr>
<td><p>Motorstørrelse:</p></td>
<td><select name="variant">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT variant, id FROM bil_variant ORDER BY id");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select></td>
</tr>
</table>
<INPUT TYPE=SUBMIT VALUE=" Søg ">
</h5>
<?
}
?>
