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
|
$recherche_auto=mysql_query ("select id,marque,modele,annee,prix,accident,carburant,kilometrage,chevaux,vehicule_etat,transmission,cylindre,couleur_inter,type_carro,couleur_carro,description
from automobile where marque='$marque' and
modele='$modele' and
annee between '$annee_debut' and '$annee_fin' and
prix between '$prix_debut' and '$prix_fin' and
accident='$accident' and
carburant='$carburant' and
kilometrage between '$kilometrage_debut' and'$kilometrage_fin' and
chevaux<='$chevaux' and
vehicule_etat='$vehicule_etat' and
transmission='$transmission' and
cylindre<='$cylindre' and
couleur_inter='$couleur_inter' and
type_carro='$type_carro' and
couleur_carro='$couleur_carro' and
description='$description'");
while ($var= mysql_fetch_array ($recherche_auto))
{
$id = $var['id'];
$marque = $var['marque'];
$modele = $var['modele'];
$annee = $var['annee'];
$prix = $var['prix'];
$carburant = $var['carburant'];
$kilometrage = $var['kilometrage'];
$chevaux = $var['chevaux'];
$vehicule_etat = $var['vehicule_etat'];
$transmission = $var['transmission'];
$cylindre = $var['cylindre'];
$couleur_inter = $var['couleur_inter'];
$type_carro = $var['type_carro'];
$couleur_carro = $var['couleur_carro'];
$description = $var['description'];
} |
Partager