PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- $db = new mysqli("localhost","root","", 'basein');
- ?>
- <html>
- <head>
- <title>Заказы</title>
- </head>
- <body>
- <?PHP
- $result1 = $db->query("SELECT DISTINCT dorozka.name, zakaz.id_time, TIME.TIME, COUNT(zakaz.id_time)
- FROM zakaz, TIME, dorozka
- WHERE TIME.id_time = zakaz.id_time
- AND dorozka.id_dorozka = zakaz.id_dorozka
- GROUP BY dorozka.name, zakaz.id_time");
- while($row = $result1->fetch_assoc()) {
- $timemap[ $row['TIME'] ] = 1;
- $namemap[ $row['name'] ] [ $row['TIME'] ] = $row['COUNT(zakaz.id_time)'];
- }
- /// "<td >" .$namemap. "</td>"
- ?>
- </body>
- </html>