Source DIREM
MySQL::query(select prod_id, date_format(prix_date,'%d/%m/%Y') , prix, taux, currency, moyen_type,
date_format(prix_date,'%Y-%m-%d') as date_tempo
from energie.PETRO_PRIX_FR
where currency = 'E' and pay_id='8' and moyen_type='h'
and prix_date >= '-01-01'
and
order by prix_date asc )
mysql_query
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by prix_date asc' at line 7
MySQL::nextRecord()
mysql_fetch_array
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by prix_date asc' at line 7 Il n'y a pas de résultat pour la période concernée
©
Ministère de l'Écologie, de l'Energie, du Développement durable et
de la Mer - Direction de l'Énergie et du Climat (DGEC),
modifié le 21/12/2009
|