How to output a table with rowspan from a MySQL query with PHP

Question

I have a problem formatting a table. I got, from a query, a set of rows similar to this one:

Now, I want to display them in a table, but grouping similar data, something like this:

So the <td> for 5 would be <td rowspan='5'> or the one for the first 23 would be <td rowspan='3'>. How can I achieve this?

I thought about making a multidimensional array storing a number for each rowspan, but the original set of rows is longer, so I got lost somewhere, and I guess there's a much easier solution.

Just the multidimentional array, and I had some ideas, but didn't try them because they wouldn't work (like checking if the last row was repeated, if so, add 1 to the rowspan... but that would be done after echoing the rowspan, so...) — Kirby
– Kirby, Commented Dec 13, 2012 at 22:20

Muatik · Accepted Answer · 2012-12-13 22:08:26Z

4

You can group the query result by column values. For example:

$grouped=array();
foreach($rows as $r)
  $grouped[ $r[0] ][ $r[1] ][]=$r[2];

answered Dec 13, 2012 at 22:08

Muatik

4,19110 gold badges44 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to output a table with rowspan from a MySQL query with PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related