function date2human ($date) { ereg ("(....)-(..)-(..) (..):(..):(..)", $date, $res); return $res[3]."/".$res[2]."/".$res[1]." à ".$res[4].":".$res[5]; } function rubriqueToImage( $r ) { return "images/pictos/c-$r.gif"; } function rubriqueToTetiere( $r ) { return "images/tetieres/t-$r.gif"; } function coupe_chaine( $s , $formes ) { $keywords = preg_split("/[ \n\r\t]+/", $s ); $s2=""; for($i=0;$i<$formes;$i++) $s2 = $s2 . " " . $keywords[$i]; return $s2 . " ..."; } include("include/include_db.phtml"); // $q = "SELECT * FROM jdi_absyde WHERE TO_DAYS(NOW())-TO_DAYS(date)<=30 ORDER by date DESC"; $q = "SELECT * FROM jdi_absyde WHERE rubrique = 'region' OR rubrique = 'finance' OR rubrique = 'barometre' ORDER by date DESC LIMIT 0,3"; $r = query_db ($q); $o[0] = mysql_fetch_object ($r); $o[1] = mysql_fetch_object ($r); $o[2] = mysql_fetch_object ($r); $q = "SELECT * FROM jdi_absyde WHERE rubrique = 'interviews' ORDER by date DESC LIMIT 0,1"; $r = query_db ($q); $o[3] = mysql_fetch_object ($r); $q = "SELECT * FROM jdi_absyde WHERE rubrique = 'technologie' ORDER by date DESC LIMIT 0,1"; $r = query_db ($q); $o[4] = mysql_fetch_object ($r); ?>