Parent Directory
| 
Revision Log
| 
Patch
| revision 3 by fraynaud, Thu Feb 10 20:46:18 2011 UTC | revision 242 by fraynaud, Wed Nov 23 19:39:04 2011 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.libelle) as etat_action_avis, nature as NT from evenement left join avis on evenement.avis=avis.avis order by evenement.libelle"; | $sql="SELECT concat(evenement,'-',evenement.libelle) as evenement,lettretype,concat(etat,' - ',action,' - ',avis.libelle) as etat_action_avis, nature as NT from ".DB_PREFIXE."evenement left join ".DB_PREFIXE."avis on evenement.avis=avis.avis order by evenement.libelle"; |
| 84 | //------------------------------------------------------------------------------ | //------------------------------------------------------------------------------ |
| 85 | ?> | ?> |
|
||||||||
| [email protected] | ViewVC Help |
| Powered by ViewVC 1.1.26 |