APPLICARE LQUERY PER TUTTI I RECORD

[Manuelandro]

<table><tr><td>King</td><td>Sommaking</td><td>clown</td><td>Sommaclown</td><td>
maxiking</td><td>minclown</td><td>avgking</td><td>avgclown</td></tr>

$dati = mysql_query ("select * from kow WHERE sq='real'");
while ($array =mysql_fetch_array($dati)) {


//TUTTO
$query = " SELECT king,SUM(king) as Sommaking,clown,SUM(clown) as Sommaclown,max(king) as maxiking,min(clown) as minclown,avg(king) as avgking,avg(clown) as avgclown FROM kow ORDER by Squadra 'Asc'";
$results = mysql_num_rows($query);
while ($row = mysql_fetch_array($result)) {

//stampi tutto
echo"<tr><td>$row[King]</td><td>$row[Sommaking] etc etc </tr>"; } 

</table>