1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
|
<td>
<select name="MIN" class="titrerecherche" style="width:95">
<option value="0" SELECTED>No Min</option>
<option value="1">100,000</option>
<option value="2">125,000</option>
<option value="3">150,000</option>
<option value="4">175,000</option>
<option value="5">200,000</option>
<option value="6">225,000</option>
<option value="7">250,000</option>
<option value="8">275,000</option>
<option value="9">300,000</option>
<option value="10">325,000</option>
...
...
...
<option value="41">2,000,000</option>
</select>
</td>
<td>
<select name="MIN" class="titrerecherche" style="width:95">
<option value="0" SELECTED>No Min</option>
<option value="1">100,000</option>
<option value="2">125,000</option>
<option value="3">150,000</option>
<option value="4">175,000</option>
<option value="5">200,000</option>
<option value="6">225,000</option>
<option value="7">250,000</option>
<option value="8">275,000</option>
<option value="9">300,000</option>
<option value="10">325,000</option>
<option value="11">350,000</option>
...
...
...
<option value="41">2,000,000</option>
</select>
</td>
$query = "select * from vente where 1=1 ";
switch($_POST["MIN"])
{
case '0':
$query .= " AND PRIX (cette partie a rajouter) 0";
break;
case '1' :
$query .= " AND PRIX (cette partie a rajouter) 100000";
break;
case '2' :
$query .= " AND PRIX (cette partie a rajouter) 125000";
break;
case '3' :
$query .= " AND PRIX (cette partie a rajouter) 150000";
break;
case '4' :
$query .= " AND PRIX (cette partie a rajouter) 175000";
break;
case '5' :
$query .= " AND PRIX (BETWEEN? :oops: ) 200000";
break;
...
...
...
}
witch($_POST["MAX"])
{
case '0':
$query .= " AND 5000000";
break;
case '1' :
$query .= " AND 100000";
break;
case '2' :
$query .= " AND 125000";
break;
case '3' :
$query .= " AND 150000";
break;
case '4' :
$query .= " AND 175000";
break;
case '5' :
$query .= " AND 200000";
break;
...
...
...
} |
Partager