dis moi: ou as tu appris ton SQL? parce que je suis pas contre l'idee de me simplifier la vie (je laisse l'autoflagellation aux autres normalement )
s'il y a de bons tutoriaux en ligne je suis preneur!

$query = ("SELECT * FROM grids_clients WHERE timeplayed BETWEEN $dateprevious AND $datecurrent");
$run_query = mysql_query($query) or die('Invalid query: ' . mysql_error());

//initialize counter: used to extract grids played by clients depending on the date 
$counter = mysql_num_rows($run_query);
//print "$counter<br><br><br>";


//loop starts
$i = 0;
while ($i < $counter)
{
$temp_grids = mysql_result($run_query,$i,"grids_1");
$client_grids = strtoArray($temp_grids);

//returns the difference between the lucky draw and the grids played by the client. returns a string
$diff = count(array_diff($client_grids, $draw));
print"$diff<br>";

//store string in an array
$array[$i]=$diff;

$i++;
}

print "<br><br>";

//count the occurences in the array: how many grids with 0, 1, 2, 3, 4, 5, 6 good numbers
$result = array_count_values($array);

//sort the array by KEY 
ksort($result);
//print_r($result);

print"
<table width=\"500\" border=\"0\">
  <tr>
    <td width=\"250\">Winning numbers per grid</td>
    <td width=\"250\">Total winners</td>
  </tr>
</table>";

//loop the array to print the result
foreach ($result as $key => $value) {
//print "$key";
//print "$value<br>"; 
$key2 = 6 - $key;

print"<table width=\"500\" border=\"0\">
	  <tr>
		<td width=\"250\">$key2</td>
		<td width=\"250\">$value</td>
	  </tr>
	</table>
	";

}

salut Tracker

je n'en suis pas encore la

tu me diras: je me complique certainement la vie a vouloir faire ce script mais bon: au moins ca sera fait!

while ($i < $counter)
{
$temp_grids = mysql_result($run_query,$i,"grids_1");
$client_grids = strtoArray($temp_grids);

$diff = count(array_diff($client_grids, $draw));
print"$diff<br>";

$array[$i]=$diff;


$i++;
}
$result = array_count_values($array);
print_r($result);

$query = ("SELECT * FROM grids_clients WHERE timeplayed BETWEEN $dateprevious AND $datecurrent");
$run_query = mysql_query($query) or die('Invalid query: ' . mysql_error());

$counter = mysql_num_rows($run_query);

$i = 0;
while ($i < $counter)
{
$temp_grids = mysql_result($run_query,$i,"grids_1");
$client_grids = strtoArray($temp_grids);

$diff = count(array_diff($client_grids, $draw));

$i++;
}