1 2 3
| $sql="SELECT $table.cle,$table.centre,$table.date,$table.heure,$table.titre,$table.x_num,$table.y_num,$table.msg,$table.utilisateur,$table.avancement,$table.histo_start,$table.site,$table.po,$table.POIDS,$table.poste_source,$table.depart,$table.heure_realisee,$table.periode,$table.type,$table.fichier,$table.fdm,$table.fdmca,$table.maj,$table.i_nip,$table.i_nitst,$table.message_prive,$table_nip.ouvrage,$table_nip.travaux,$table_nitst.objet,$table_nitst.n_bt,$table_nitst.observations FROM $table,$table_nip,$table_nitst WHERE (date like '%$us_date%') AND $table_nip.cle=$table.i_nip AND $table_nitst.cle=$table.i_nitst AND $table.utilisateur IN ('ACR', 'AMNMP', 'ARELGC', 'ARER', 'ARETG', 'ARETN', 'ARETS', 'LOT')";
$sql=$sql. $criteres;
$sql=$sql. " ORDER BY FIND_IN_SET ($table.utilisateur, 'ACR', 'AMNMP', 'ARELGC', 'ARER', 'ARETN', 'ARETS', 'ARETG', 'LOT');"; |
Partager