Group By Headers in php from SQL query

Question

So here is the table I get from a query:

----------+----+-----------+----------------------
45678-sm-w| 18 |T-Shirts   | Mens clothing
----------+----+-----------+----------------------
45678-sm-b|  5 |T-Shirts   | Mens clothing
----------+----+-----------+----------------------
2189-L-Wh |  4 | Socks     | Juniors Clothing
----------+----+-----------+----------------------
2189-L-Bl |  3 | Socks     | Juniors Clothing
----------+----+-----+-----+----------------------

I want to put into a report the looks like:

T-Shirts
----------+----+-----------+----------------------
45678-sm-w| 18 |T-Shirts   | Mens clothing
----------+----+-----------+----------------------
45678-sm-b|  5 |T-Shirts   | Mens clothing
----------+----+-----------+----------------------

Socks
 ----------+----+-----------+----------------------
2189-L-Wh |  4 | Socks     | Juniors Clothing
----------+----+-----------+----------------------
2189-L-Bl |  3 | Socks     | Juniors Clothing
----------+----+-----+-----+----------------------

I know it is done through a loop but cannot figure it out. Thanks!

I dont know where to begin. You dont need to vote down my question. — Tyler Nichol
– Tyler Nichol, Commented Oct 12, 2012 at 19:57
Once the question shows effort and is edited, I can remove my down vote. — Kermit
– Kermit, Commented Oct 12, 2012 at 20:04

blackcatweb · Accepted Answer · 2012-10-12 20:10:53Z

4

Try ordering your query by item type and force a header when the current header changes.

$res = mysql_query("select * from clothing order by item_type, item_size");

$item_type=null;
while ($row = mysql_fetch_assoc($res)) {
    if ($item_type != $row['item_type']) {
        $item_type = $row['item_type'];
        echo $item_type . "\r\n";
    }
    echo $row["item_name"];
    echo $row["item_size"];
    echo $row["item_desc"];
}

answered Oct 12, 2012 at 20:10

blackcatweb

1,0531 gold badge12 silver badges12 bronze badges

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

1 Comment

Tyler Nichol Over a year ago

Thank you very much works great. A little format tweaking and it is just what I needed.

Collectives™ on Stack Overflow

Group By Headers in php from SQL query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related