Subversion Repositories Applications.bazar

Rev

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

Rev 434 Rev 439
Line 1203... Line 1203...
1203
	if ($requeteSQL!='') {
1203
	if ($requeteSQL!='') {
1204
		if ($req_where==1) {$requete .= ' AND ';}
1204
		if ($req_where==1) {$requete .= ' AND ';}
1205
		$requete .= '('.$requeteSQL.')';
1205
		$requete .= '('.$requeteSQL.')';
1206
		$req_where=1;
1206
		$req_where=1;
1207
	}
1207
	}
1208
	$requete .= ' ORDER BY  bf_date_debut_validite_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
1208
	$requete .= 'GROUP BY bf_id_fiche ORDER BY  bf_date_debut_validite_fiche DESC, bf_date_fin_validite_fiche DESC, bf_date_maj_fiche DESC';
1209
	if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
1209
	if ($nbitem!='') {$requete .= ' LIMIT 0,'.$nbitem;}
1210
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
1210
	$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
1211
	if (DB::isError($resultat)) {
1211
	if (DB::isError($resultat)) {
1212
		return  $resultat->getMessage().'<br /><br />'.$resultat->getDebugInfo() ;
1212
		return  $resultat->getMessage().'<br /><br />'.$resultat->getDebugInfo() ;
1213
	}
1213
	}