require "connexion.php"; $query = query("SELECT valeur,DATE_FORMAT(date,'%d/%m/%Y') as datefr FROM taux WHERE nom = 'eonia' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $eonia = $val['valeur']; $date = $val['datefr']; $query = query("SELECT valeur FROM taux WHERE nom = 'oat_5a' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $oat_05a = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'oat_10a' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $oat_10a = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'euribor_1m' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $euribor_01m = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'euribor_3m' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $euribor_03m = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'euribor_12m' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $euribor_12m = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'usd' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $usd = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'jpn' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $jpn = $val['valeur']; $query = query("SELECT valeur FROM taux WHERE nom = 'gbp' ORDER BY DATE DESC LIMIT 1"); $val = mysql_fetch_assoc($query); $gbp = $val['valeur']; ?>
|
||||||||||||||