$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);
if($line=mysql_fetch_array($result_showcount)){
$showcount = $line['showcount'];
}
if ($showcount > 5) {
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}";
echo "1";
if ($showname!=="") {
echo "| ".$showname." | ".$showtime2." |
";
} else {
echo "| ajouter votre nom |
";
};
}