Problème de requête (2) [TITRE MODERE CAR PEU EXPLICITE]

j'ai pas eu de suite pour la question que jai poser sur cette adresse et c'est tres important pour moi
http://www.phpcs.com/forum.v2.aspx?ID=632801

Salut,

merci de mettre un sujet plus explicite. Ensuite nous ne sommes pas là pour réaliser des scripts PHP. Si tu ne sais pas réaliser un script et que t'en as besoin, tu as des sociétés qui pouront très bien le faire :-)

a +

---

• Entraide, dépannage et vulgarisation informatique : Mon site de vulgarisation informatique
• Codes-php.net

Montre nous ton source au moins que l'on puisse comprendre ce que tu fais et voir si il n'y a pas une erreur. Parce que là je pense pas les gens soit de mauvaise fois, on est là pour t'aider et guider, on peu également t'expliquer certaine chose. Mais on est pas là pour faire ton boulot.

@+

Stu 76

Salut,

envoi nous ton code et détaille plus...


In a dream, I saw me, drop dead... U was there, U cried... It was just a dream, if I die, U won't cry, maybe, U'll be happy

Mon site (articles sur la programmation et programmes)

le code source :

<?
session_start();
?>
<?php require_once('Connections/Connexion_Agence.php'); ?>
<?php
$typ_Reff = 0;
if (isset($HTTP_POST_VARS['typeID'])) {
  $typ_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['typeID'] : addslashes($HTTP_POST_VARS['typeID']);
}
$pieces_Reff = 0;
if (isset($HTTP_POST_VARS['picesID'])) {
  $pieces_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['picesID'] : addslashes($HTTP_POST_VARS['picesID']);
}
$vill_Reff = 0;
if (isset($HTTP_POST_VARS['villeID'])) {
  $vill_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['villeID'] : addslashes($HTTP_POST_VARS['villeID']);
}
$surmin_Reff = 0;
if (isset($HTTP_POST_VARS['surfmin'])) {
  $surmin_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['surfmin'] : addslashes($HTTP_POST_VARS['surfmin']);
}
$primin_Reff = 0;
if (isset($HTTP_POST_VARS['prixmin'])) {
  $primin_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['prixmin'] : addslashes($HTTP_POST_VARS['prixmin']);
}
$surmax_Reff = 0;
if (isset($HTTP_POST_VARS['surfmax'])) {
  $surmax_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['surfmax'] : addslashes($HTTP_POST_VARS['surfmax']);
}
$primax_Reff = 0;
if (isset($HTTP_POST_VARS['prixmax'])) {
  $primax_Reff = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['prixmax'] : addslashes($HTTP_POST_VARS['prixmax']);
}

mysql_select_db($database_Connexion_Agence, $Connexion_Agence);

/////////////////   tout les cas

///////////////////////////////////// 1

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = 'ssss'");
}

///////////////////////////////////// 2

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' ",$pieces_Reff);
}

///////////////////////////////////// 3

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' ", $typ_Reff);
}

///////////////////////////////////// 4

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE ville='%s'",$vill_Reff);
}

///////////////////////////////////// 5

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface >= '%s' ", $surmin_Reff);
}

///////////////////////////////////// 6

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface <= '%s' ", $surmax_Reff);
}

///////////////////////////////////// 7

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE prix >= '%s' ", $primin_Reff);
}

///////////////////////////////////// 8

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE prix <= '%s' ", $primax_Reff);
}

///////////////////////////////////// 9

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices = '%s' ", $typ_Reff, $pieces_Reff);
}

///////////////////////////////////// 10

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' and ville = '%s' ", $pieces_Reff, $vill_Reff);
}

///////////////////////////////////// 11

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' and surface >= '%s'", $pieces_Reff,$surmin_Reff);
}

///////////////////////////////////// 12

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' and surface <= '%s'", $pieces_Reff,$surmax_Reff);
}

///////////////////////////////////// 13
if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' and prix >= '%s'", $pieces_Reff,$primin_Reff);
}

///////////////////////////////////// 14

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices = '%s' and prix <= '%s'", $pieces_Reff,$primax_Reff);
}

///////////////////////////////////// 15
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s'", $typ_Reff,$vill_Reff);
}

///////////////////////////////////// 16
if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE ville = '%s' and surface >= '%s'", $vill_Reff,$surmin_Reff);
}

///////////////////////////////////// 17
if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface between '%s' and '%s'", $surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 18
if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface <= '%s' and prix >= '%s'", $surmax_Reff,$primin_Reff);
}

///////////////////////////////////// 19
if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE prix between '%s' and '%s'", $primin_Reff,$primax_Reff);
}

///////////////////////////////////// 20
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type='%s' and ville='%s' and surface >= '%s'",$typ_Reff,$vill_Reff, $surmin_Reff);
}

///////////////////////////////////// 21
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type='%s' and ville='%s' and surface <= '%s'",$typ_Reff,$vill_Reff, $surmax_Reff);
}

///////////////////////////////////// 22
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type='%s' and ville='%s' and prix >= '%s'",$typ_Reff,$vill_Reff, $primin_Reff);
}

///////////////////////////////////// 23
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type='%s' and ville='%s' and prix <= '%s'",$typ_Reff,$vill_Reff, $primax_Reff);
}

///////////////////////////////////// 24
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type='%s' and ville='%s' and surface between '%s' and '%s'",$typ_Reff,$vill_Reff, $surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 25

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and surface >= '%s' and prix > '%s' ", $typ_Reff,$vill_Reff, $surmin_Reff,$primin_Reff);
}

///////////////////////////////////// 26
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and surface >= '%s' and prix < '%s' ", $typ_Reff,$vill_Reff, $surmin_Reff,$primax_Reff);
}
///////////////////////////////////// 27

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and  prix >= '%s' and surface between '%s' and '%s'", $typ_Reff,$vill_Reff, $primin_Reff,$surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 28

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and  prix <= '%s' and surface between '%s' and '%s'", $typ_Reff,$vill_Reff, $primax_Reff,$surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 29
if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and  prix between '%s' and '%s' and surface between '%s' and '%s'", $typ_Reff,$vill_Reff, $primin_Reff, $primax_Reff, $surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 30

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and  prix between '%s' and '%s' and surface between '%s' and '%s'", $pieces_Reff, $typ_Reff,$vill_Reff, $primin_Reff, $primax_Reff, $surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 31

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s' and ville='%s'", $typ_Reff,$pieces_Reff,$vill_Reff);
}

///////////////////////////////////// 32

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s' and ville='%s' and surface >= '%s'", $typ_Reff,$pieces_Reff,$vill_Reff,$surmin_Reff);
}

///////////////////////////////////// 33

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s' and ville='%s' and surface between '%s' and '%s'", $typ_Reff,$pieces_Reff,$vill_Reff,$surmin_Reff,$surmax_Reff);
}

///////////////////////////////////// 34

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s' and ville='%s' and surface between '%s' and '%s' and prix >= '%s'", $typ_Reff,$pieces_Reff,$vill_Reff,$surmin_Reff,$surmax_Reff,$primin_Reff);
}

///////////////////////////////////// 35

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s'  and surface <= '%s' and prix between '%s' and '%s'", $typ_Reff,$pieces_Reff,$surmax_Reff,$primin_Reff,$primax_Reff);
}

///////////////////////////////////// 36

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and ville ='%s' and surface >= '%s'",$pieces_Reff, $vill_Reff, $surmin);
}

///////////////////////////////////// 37

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and surface between '%s' and '%s'", $pieces_Reff, $surmin_Reff, $surmax_Reff);
}

///////////////////////////////////// 38

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and surface <= '%s' and prix >= '%s'",$pieces_Reff, $surmax_Reff, $primin_Reff);
}

///////////////////////////////////// 39

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and prix between '%s' and '%s'",$pieces_Reff, $primin_Reff, $primax_Reff);
}

///////////////////////////////////// 40

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type = '%s' and ville='%s' and prix <= '%s'",$pieces_Reff, $typ_Reff, $vill_Reff, $primax_Reff);
}

///////////////////////////////////// 41 comme 32

///////////////////////////////////// 42

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type='%s' and ville='%s' and surface >= '%s' and prix >= '%s'", $pieces_Reff, $typ_Reff, $vill_Reff, $surmin_Reff, $primin_Reff);
}

///////////////////////////////////// 43

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type='%s' and ville='%s' and surface >= '%s' and prix <= '%s'", $pieces_Reff, $typ_Reff, $vill_Reff, $surmin_Reff, $primax_Reff);
}

///////////////////////////////////// 44

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type='%s' and ville='%s' and prix <= '%s' and surface between '%s' and '%s'", $pieces_Reff, $typ_Reff, $vill_Reff, $primax_Reff, $surmin_Reff, $surmax_Reff);
}

///////////////////////////////////// 45

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and ville='%s' and prix between '%s' and '%s' and surface between '%s' and '%s'", $pieces_Reff, $vill_Reff, $primin_Reff, $primax_Reff, $surmin_Reff, $surmax_Reff);
}

///////////////////////////////////// 46

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and prix between '%s' and '%s' and surface between '%s' and '%s'", $pieces_Reff, $primin_Reff, $primax_Reff, $surmin_Reff, $surmax_Reff);
}

///////////////////////////////////// 47

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type='%s' and prix <= '%s'" ,$pieces_Reff, $typ_Reff , $primax_Reff);
}

///////////////////////////////////// 48

if ($HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and surface >= '%s' and prix between '%s' and '%s'",$pieces_Reff , $surmin_Reff, $primin_Reff, $primax_Reff);
}

///////////////////////////////////// 49

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE pices='%s' and type ='%s' and prix between '%s' and '%s'",$pieces_Reff , $typ_Reff, $primin_Reff, $primax_Reff);
}

///////////////////////////////////// 50 ya un cas qui es reperter je ne lai pas localiser

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville = '%s' and surface <= '%s' and prix >= '%s'" , $typ_Reff, $vill_Reff, $surmin_Reff, $primax_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville ='%s' and prix between '%s' and '%s'", $typ_Reff, $vill_Reff, $primin_Reff, $primax_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface >= '%s' and prix <='%s'", $surmin_Reff, $primax_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && !$HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE surface >= '%s' and prix >='%s'", $surmin_Reff, $primin_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && !$HTTP_POST_VARS['surfmin'] && !$HTTP_POST_VARS['surfmax'] && $HTTP_POST_VARS['prixmin'] && $HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and prix between '%s' and '%s'", $typ_Reff, $primin_Reff, $primax_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and surface between '%s' and '%s'", $typ_Reff, $surmin_Reff, $surmax_Reff);
}

if (!$HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and surface between '%s' and '%s'", $typ_Reff, $vill_Reff, $surmin_Reff, $surmax_Reff);
}

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && !$HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and pices='%s' and surface between '%s' and '%s'", $typ_Reff, $pieces_Reff, $surmin_Reff, $surmax_Reff);
}

if ($HTTP_POST_VARS['picesID'] && $HTTP_POST_VARS['typeID'] && $HTTP_POST_VARS['villeID'] && $HTTP_POST_VARS['surfmin'] && $HTTP_POST_VARS['surfmax'] && !$HTTP_POST_VARS['prixmin'] && !$HTTP_POST_VARS['prixmax'] )
{
$query_Reff = sprintf("SELECT * FROM bien WHERE type = '%s' and ville='%s' and pices='%s' and surface between '%s' and '%s'", $typ_Reff, $vill_Reff, $pieces_Reff, $surmin_Reff, $surmax_Reff);
}

/////////////////   tout les cas

$Reff = mysql_query($query_Reff, $Connexion_Agence) or die(mysql_error());
$row_Reff = mysql_fetch_assoc($Reff);
$totalRows_Reff = mysql_num_rows($Reff);

?>

<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a {
 color: <? echo $_SESSION['txt']; ?>;
 text-decoration: underline;
 font-weight: bold;
}
a:hover {
 color: #FFFFCC;
 text-decoration: none;
}

-->
</style>
</head>

<body bgcolor="<? echo $_SESSION['fnt']; ?>">
<?php

function miniature($chemin_original, $chemin_mini, $fichier_image, $largeur_mini)
  {
  $image_origine = imagecreatefromjpeg("$chemin_original/$fichier_image");
  $largeur_origine = imagesx($image_origine);
  $hauteur_origine = imagesy($image_origine);
  $hauteur_mini = $hauteur_origine * $largeur_mini /   $largeur_origine;
  $image_finale = imagecreatetruecolor($largeur_mini, $hauteur_mini);
  imagecopyresized($image_finale, $image_origine, 0, 0, 0, 0,   $largeur_mini, $hauteur_mini, imagesx($image_origine), imagesy($image_origine) );
  imagejpeg($image_finale, "$chemin_mini/"."mini_"."$fichier_image");
  imagedestroy($image_finale);

  return true;
  }
?>

<?Php
if ($totalRows_Reff != 0)
{
?>

<div align="center"><br>
  <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="<? echo $_SESSION['txt']; ?>">&nbsp;&nbsp;&nbsp;&nbsp;<font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>&nbsp;&nbsp;&nbsp;&nbsp;Le
  resultat de la recherce contien &nbsp;<? echo $totalRows_Reff; ?> </strong></font></font>
  <font color="<? echo $_SESSION['txt']; ?>">Bien(s) </font></strong></font><br>
  <br>
  <?php do { ?>
  <TABLE width=760 align=center id=exterieur>
    <TBODY>
      <TR vAlign=top>
        <td width=115 rowspan="2"> <div style="width:115px;height:115px;filter:shadow(color:black,strength:8, direction:135);">
<?Php
      $fichier = "principale.jpg";
            $rep = "Photos/".$row_Reff['reference'];
      $verif = $rep."/".$fichier;
      if (file_exists($verif))
      {
      miniature($rep , $rep , $fichier, 100);
      ?>
        <A onclick="javascript:window.open('photos.php?reff=<? echo $rep; ?>', '','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,width=663,height=525');"
            href="javascript:;"> <img alt="Cliquer pour plus de photos"
   src = "<?Php echo "$rep"."/mini_"."$fichier"; ?>" align=top border="0"> </A>
      <?Php
      }
      else
      {
     ?>
      <img alt="Cliquer pour plus de photos" src = "Photos/no_photo.jpg" ; align=top border="0"> 
          <?Php
   }
   ?> </div></td>
        <TD width="701"> <TABLE width="100%">
            <TBODY>
              <TR>
                <TH width="20%" bgColor=#666666><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['type']; ?></font></TH>
                <TH width="62%" bgColor=#666666><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['ville']; ?></font></TH>
                <TH width="18%" bgColor=#666666><div align="right"><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['prix']; ?> DA</font></div></TH>
              </TR>
              <TR>
                <TD height="83" vAlign=top> <TABLE width="100%">
                    <TBODY>
                      <TR>
                        <TD><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['pices']; ?></font></TD>
                      </TR>
                      <TR>
                        <TD><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['surface']; ?> m&sup2;</font></TD>
                      </TR>
                      <TR>
                        <TD height="18"><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif">Ref:<?php echo $row_Reff['reference']; ?></font></TD>
                      </TR>
                    </TBODY>
                  </TABLE>
                  <font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;<?php echo $row_Reff['vl']; ?></font><font color="<? echo $_SESSION['txt']; ?>">&nbsp;</font></TD>
                <TD vAlign=top colSpan=2><p><font color="<? echo $_SESSION['txt']; ?>" size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_Reff['details']; ?></font></p></TD>
              </TR>
            </TBODY>
          </TABLE></TD>
      </TR>
    </TBODY>
  </TABLE>
  <?php } while ($row_Reff = mysql_fetch_assoc($Reff)); ?>
</div>
<p>
</p>
<?
}
else
{
?>
<p></p>
<div align="center"><font color="<? echo $_SESSION['txt']; ?>"><br><br><br>D&eacute;sol&eacute;, nous n'avons pas
  le bien correspondant &agrave; vos crit&egrave;res.<br>
  N'h&eacute;sitez pas &agrave; <a href="contact.php">contacter</a> l'agence,
  nous pourrons vous aider dans votre recherche. </font> </div>
<?
}
?>
</body>
</html>
<?php
mysql_free_result($Reff);
?>

je sais que la partie en rouge peut etre resumer avec un code optimal, je sais pas le faire.
je remercie coucou747 et stu76

Oh lalalala... j'ai tellement eu mal aux yeux que je me suis arrété au tout début :o

Toi aussi ?

---

• Entraide, dépannage et vulgarisation informatique : Mon site de vulgarisation informatique
• Codes-php.net

Salut,

désolé, je me suis arrété aux 4 premières lignes...


<?
session_start();
?>
<?php require_once('Connections/Connexion_Agence.php'); ?>
<?php


pourquoi ouvrir php pour le fermer ensuite ?

le code suivant est aussi efficace :

<?php
session_start();
echo '
';
require_once('Connections/Connexion_Agence.php');
echo '
';
?>

et je supposes que tu voulais mettre :


<?php
session_start();
require_once('Connections/Connexion_Agence.php');
?>


Un conseil, met ton code au propre et reposte la partie php, car la, il est bien trop brouillon pour être lu...

In a dream, I saw me, drop dead... U was there, U cried... It was just a dream, if I die, U won't cry, maybe, U'll be happy

Mon site (articles sur la programmation et programmes)

echo '
';

t'affiches des sauts de ligne ?

---

• Entraide, dépannage et vulgarisation informatique : Mon site de vulgarisation informatique
• Codes-php.net

Salut,

son code en affichait...


In a dream, I saw me, drop dead... U was there, U cried... It was just a dream, if I die, U won't cry, maybe, U'll be happy

Mon site (articles sur la programmation et programmes)