MySQL (or PHP?) group results by field data

by

This would my solution, althoug is not elegant at all

<?php
$dbc = new MySQLI(DBHOST,DBUSER,DBPASS,DB);
$result = $dbc->query("
SELECT
p.Group as 'group',
GROUP_CONCAT(name) as names
FROM prueba p
GROUP BY p.Group
");
?>
<table>
<tr>
    <th>Group</th>
    <th>Name</th>
</tr>
<?php while($row = $result->fetch_assoc()){
    $names = split(",",$row["names"]);
?>
    <tr>
        <td><?php echo $row["group"] ?> </td>
        <td><?php echo $names[0]; array_shift($names) ?></td>
    </tr>
    <?php foreach( $names as $name){ ?>
        <tr>
            <td></td>
            <td><?php echo $name ?></td>
        </tr>
    <?php } ?>
<?php } ?>
</table>

More Related Contents:

  1. Aggregated query without GROUP BY
  2. Using PHP data in MySQL [closed]
  3. How to sort user data by id
  4. Select those record only from table 1 where city exist against state id in table 2 in PHP
  5. PHP PDO prepared statements
  6. mysqli::query(): Couldn’t fetch mysqli
  7. select count(*) from table of mysql in php
  8. Loading .sql files from within PHP
  9. Incorrect Integer (2147483647) is inserted into MySQL?
  10. I need my PHP page to show my BLOB image from mysql database
  11. Delete multiple rows by selecting checkboxes using PHP
  12. Object of class DateTime could not be converted to string
  13. PHP Commands Out of Sync error
  14. PHP MYSQL UPDATE if Exist or INSERT if not?
  15. mysql_real_escape_string VS addslashes
  16. How I can create installer for website. PHP mysql [closed]
  17. “No such file or directory” or “No such host is known” when running migrations
  18. How to convert IPv6 from binary for storage in MySQL
  19. Using Prepared Statement, how I return the id of the inserted row?
  20. Replacing \r\n with PHP
  21. How to check if a value already exists to avoid duplicates?
  22. How to use MySQL Found_Rows() in PHP?
  23. How does {} affect a MySQL Query in PHP? [duplicate]
  24. When should I close a database connection in PHP?
  25. Backup a mysql database and download as a file
  26. MYSQL select a piece of a string and order by that piece
  27. Is a BLOB converted using the current/default charset in MySQL?
  28. php connection pooling mysql [duplicate]
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment