PHPize Online / SQLize Online  /  SQLtest Online

<?php $query = 'SELECT `methods`.* FROM `methods` LEFT JOIN `groups` ON `groups`.`id` = `methods`.`group_id` WHERE `methods`.`active` = ? AND `groups`.`active` = ? ORDER BY `methods`.`group_id`, `methods`.`position`;'; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute([1, 1]); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $group_id = $row['group_id']; printf( '<ul data-group_id="%d">' . PHP_EOL . ' <li data-id="%d">%s</li>' . PHP_EOL, $group_id, $row['id'], $roe['name'] ); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { if ($group_id != $row['group_id']) { $group_id = $row['group_id']; printf( '</ul><ul data-group_id="%d">' . PHP_EOL, $group_id ); } printf(' <li data-id="%d">%s</li>' . PHP_EOL, $row['id'], $roe['name']); } printf('</ul>'); }