Форум АНТИЧАТ

вот сам алгоритм работы в пхп
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;                                                   

                                                                                            }

                                                                                                               

                                                                                                                }