= (CURDATE() - INTERVAL $ultimele_zile DAY )"; foreach ($numere_cautate as $numar_cautat) { echo ''; echo ''; echo ''; $prima_pauza = false; $pauza = $pauza_curenta = $pauza_maxima = 0; $ultimele_extrageri = mysql_query("SELECT * FROM extrageri WHERE id ".$cu_limita." ORDER BY id DESC"); $numar_ultimele_extrageri = mysql_num_rows($ultimele_extrageri); while ($rand = mysql_fetch_assoc($ultimele_extrageri)) { $numere = str_replace(" ", "", $rand['numere']); $numere_array = explode(",", $numere); if (!in_array($numar_cautat, $numere_array)) { $pauza++; if ($pauza > $pauza_maxima) $pauza_maxima = $pauza; } else { if ($prima_pauza == false) { $pauza_curenta = $pauza; $prima_pauza = true; $pauza = 0; } } if ($aparitii == 0) $pauza_curenta = $pauza_maxima = $numar_ultimele_extrageri; } $medie = number_format(($aparitii * 100)/$numar_ultimele_extrageri, 2); echo ''; echo ''; echo ''; echo ''; } } ?>
Nr. Aparitii Pauza Pauza max. Media
'.$numar_cautat.''; $aparitii = mysql_num_rows(mysql_query("SELECT * FROM extrageri WHERE FIND_IN_SET('".$numar_cautat."', numere) > 0 ".$cu_limita." ORDER BY id DESC ")); echo $aparitii; echo ''.$pauza_curenta.''.$pauza_maxima.''.$medie.'%