Parent Directory
| 
Revision Log
| 
Patch
| revision 489 by vpihour, Thu Oct 11 08:27:21 2012 UTC | revision 510 by vpihour, Wed Oct 17 11:02:35 2012 UTC | |
|---|---|---|
| # | Line 80 $a2="L"; | Line 80 $a2="L"; |
| 80 | $a3="L"; | $a3="L"; |
| 81 | //--------------------------SQL------------------------------------------------- | //--------------------------SQL------------------------------------------------- |
| 82 | //$sql="SELECT (code||' '|| cp || ' '|| ville) as code,libelle_voie from voie order by libelle_voie"; | //$sql="SELECT (code||' '|| cp || ' '|| ville) as code,libelle_voie from voie order by libelle_voie"; |
| 83 | $sql="SELECT concat(evenement,'-',evenement.libelle) as evenement,lettretype,concat(etat,' - ',action,' - ',avis_decision.libelle) as etat_action_avis, nature as NT from ".DB_PREFIXE."evenement left join ".DB_PREFIXE."avis_decision on evenement.avis_decision=avis_decision.avis_decision order by evenement.libelle"; | $sql="SELECT concat(evenement,'-',evenement.libelle) as evenement,lettretype,concat(etat,' - ',action,' - ',avis_decision.libelle) as etat_action_avis_decision, nature as NT from ".DB_PREFIXE."evenement left join ".DB_PREFIXE."avis_decision on evenement.avis_decision=avis_decision.avis_decision order by evenement.libelle"; |
| 84 | //------------------------------------------------------------------------------ | //------------------------------------------------------------------------------ |
| 85 | ?> | ?> |
|
||||||||
| [email protected] | ViewVC Help |
| Powered by ViewVC 1.1.26 |