Subversion Repositories Applications.bazar

Rev

Rev 452 | Rev 456 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 452 Rev 455
Line 711... Line 711...
711 
		if ($req_where==1) {$requete .= ' AND ';}
 711 
		if ($req_where==1) {$requete .= ' AND ';}
712 
		$requete .= 'bn_ce_id_menu IN ('.$categorie_nature.') and bf_ce_nature=bn_id_nature ';
 712 
		$requete .= 'bn_ce_id_menu IN ('.$categorie_nature.') and bf_ce_nature=bn_id_nature ';
713 
		$req_where=1;
 713 
		$req_where=1;
714 
	}
 714 
	}
Line -... Line 715...
- 
 
 715
- 
 
 716 
	if (isset($_REQUEST['departement'])) {
- 
 
 717 
		  if ($req_where==1) {$requete .= ' AND ';}
- 
 
 718 
		  $requete .= ' bf_cp_lieu_evenement LIKE "'.$_REQUEST['departement'].'%" ';
- 
 
 719 
	}
715 
 
 720 
 
716 
	$requete .= ' ORDER BY   bf_date_creation_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
 721 
	$requete .= ' ORDER BY   bf_date_creation_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
717 
	if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
 722 
	if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
Line 718... Line 723...
718 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
 723 
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;