вот сам алгоритм работы в пхп PHP: $res= 'SELECT DISTINCT ppersons.Surname, ppersons.Name, ppersons.Fathername, ppersons.RoadName, ppersons.Email, ppersons.RoadPhone, ppersons.fio_dat, users.UserLogin, users.UserPassword, courses.CourseName, courses.HourWeight, max( stat_tests.StatTestResult ) as maxres FROM stat_tests INNER JOIN users ON ( stat_tests.UserID = users.UserID ) INNER JOIN ppersons ON ( users.UserLink = ppersons.PPersonID ) INNER JOIN courses ON ( stat_tests.TestID = courses.CourseID ) WHERE stat_tests.StatTestResult >= 0.75 and users.UserLogin LIKE \'%user%\' GROUP BY courses.CourseName, courses.HourWeight, users.UserLogin ORDER BY users.UserLogin, courses.CourseName'; $dataset2 = $db->query($res); if($db->ERRORCODE==0){ $i=0; $colcount = mysql_num_rows($dataset2); while ($row=mysql_fetch_array($dataset2)) { $i=$i+1; $massiv[$i]["Surname"]=$row["Surname"]; $massiv[$i]["Name"]=$row["Name"]; $massiv[$i]["Fathername"]=$row["Fathername"]; $massiv[$i]["RoadName"]=$row["RoadName"]; $massiv[$i]["Email"]=$row["Email"]; $massiv[$i]["RoadPhone"]=$row["RoadPhone"]; $massiv[$i]["UserLogin"]=$row["UserLogin"]; $massiv[$i]["UserPassword"]=$row["UserPassword"]; $massiv[$i]["CourseName"]=$row["CourseName"]; $massiv[$i]["HourWeight"]=$row["HourWeight"]; $massiv[$i]["maxres"]=$row["maxres"]; $massiv[$i]["fio_dat"]=$row["fio_dat"]; } } for ($i=1;$i<=$colcount;$i++) { $summa=0; print "<tr ALIGN='center' BGCOLOR='#F0F0F0'>"; print "<td ALIGN='center'><b>".$massiv[$i]["Fathername"]."</b></td>"; print "<td ALIGN='center'><b>".$massiv[$i]["Name"]."</b></td>"; print "<td ALIGN='center'><b>".$massiv[$i]["Surname"]."</b></td>"; print "<td ALIGN='center'><b>".$massiv[$i]["UserLogin"]."</b></td>"; print "<td ALIGN='center'><b>".$massiv[$i]["UserPassword"]."</b></td>"; print "<td ALIGN='center'><b>".$massiv[$i]["RoadName"]."</b></td>"; for ($j=$i;$j<=$colcount;$j++) { if($massiv[$i]["UserLogin"]==$massiv[$j]["UserLogin"]) { $summa=$summa+$massiv[$j]["HourWeight"];} else { break;}} if (($id==$massiv[$i]["UserLogin"])&&($flag==0)) { print "<td ALIGN='center'><b><a href='result.php?id=".$massiv[$i]["UserLogin"]."&flag=1' class='redakt'>".$summa."<a></b></td>"; } elseif(($id==$massiv[$i]["UserLogin"])&&($flag==1)){print "<td ALIGN='center'><b><a href='result.php?id=".$massiv[$i]["UserLogin"]."&flag=0' class='redakt'>".$summa."<a></b></td>";} else{ print "<td ALIGN='center'><b><a href='result.php?id=".$massiv[$i]["UserLogin"]."&flag=1' class='redakt'>".$summa."<a></b></td>"; } print "</tr>"; if (($id==$massiv[$i]["UserLogin"])&&($flag==1)){ print "<tr ALIGN='center' BGCOLOR='#F4F4F4'>"; print "<td colspan='6'><p class='admin1'>Подробности обучения</td></tr>"; print "<tr BGCOLOR='#F4F4F4'>"; print "<td colspan='6'> E-mail: <b>".$massiv[$i]["Email"]."</b><br> Телефон: <b>".$massiv[$i]["RoadPhone"]."</b><br> Дорога: <b>".$massiv[$i]["RoadName"]."</b><br> ФИО в дательном падеже: <b>".$massiv[$i]["fio_dat"]."</b></td>"; print "</tr>"; print "<tr ALIGN='center' BGCOLOR='#F9F9F9'>"; print "<td colspan='4'><p class='admin2'>Курс:</p></td>"; print "<td><p class='admin2'>Часовой вес:</td>"; print "<td><p class='admin2'>Лучший результат:</td>"; print "</tr>"; for ($z=$i;$z<$j;$z++) { print "<tr BGCOLOR='#FBECEE' ALIGN='center'>"; print "<td colspan='4'><p class='zakaz'>".$massiv[$z]["CourseName"]."</p></td>"; print "<td><p class='zakaz'>".$massiv[$z]["HourWeight"]."</p></td>"; print "<td><p class='zakaz'>".$massiv[$z]["maxres"]."</p></td>"; print "</tr>"; } } $i=$j-1; } }