= subdate(now(), Interval 1 second) order by showtime desc limit 0,5"; $resultshowtime=mysql_query($showtimes) or die("query failed : ".$showtimes) ; $show_count = "select count(*) as showcount from cr_members where showtime >= subdate(now(), Interval 1 second) order by showtime desc"; $result_showcount = mysql_query($show_count) or die("query failed : ".$show_count); echo "

"; echo ""; while($line = mysql_fetch_array($resultshowtime)){ $showname = $line['userid']; $showtime = $line['showtime']; list($date, $time) = explode(" ", $showtime); list($year, $month, $day) = explode("-", $date); list($hour, $min) = explode(":", $time); $months = array("janvier", "février", "mars", "avril", "mai", "juin","juillet", "août", "septembre", "octobre", "novembre", "décembre"); $showtime2 = "$day ".$months[$month-1]." ${hour}h${min}"; if ( showcount < 5 ) { echo ""; } else { echo ""; } } echo " ajouter votre nom ".$showname."   ".$showtime2." "; echo "

"; ?>