2-tabellen-join-count-grop.php

Quell Code

<?php

/*
              $mysqli=mysqli_connect("localhost", "sebastian1012", "123456789", "sebastian1012");
              if (mysqli_connect_errno())      die ("Connect failed: " . mysqli_connect_error());     
              mysqli_set_charset($mysqli, "utf8");



//$sql = "SELECT t.name, c.catid, c.catname FROM tenses t, tensecategory c WHERE t.catid=c.catid";

$number_of_workouts = array();
$query = "SELECT *  COUNT(*)
     FROM tenses, tensecategory
     WHERE `(SELECT catid from tenses) = (SELECT catid from tensecategory)
     GROUP BY t.name";

$result = mysqli_query($mysqli, $query)  or die ("MySQL-Error: " . mysqli_error($mysqli));
print_r(mysqli_fetch_all($result));
*/

/*
$result = $mysqli->query($sql);

$tenseinfo = [];
foreach ($result as $row) {
    if (!isset($tenseinfo[$row['catid']])) {
        $tenseinfo[$row['catid']] = ['catname' => $row['catname'], 'tenses' => [$row['name']]];
    } else {
        $tenseinfo[$row['catid']]['tenses'][] = $row['name'];
    }
}
*/

echo "<pre>";
print_r($tenseinfo);
echo "</pre>";





?>