grouping a list

Anon

Hello,

I want to try to group a list of items from my database. I have done a group by in my statement, but I want to try to get something to this affect:

CATEGORY A
product 1
product 2
product 3

CATEGORY B
product 1
product 2

I have tried doing this using includes for each category but because they are querying the same fields for some reason it only takes the last query? I guess it can't cross query the same stuff. I am thinking that I would have to setup an array that would loop? Since I am fairly new to this, can someone give me a direction/start on how to accomplish this.

Thanks,

Brett

jcornett

I think I know what you are trying to get done... Perhaps the code below will help:

$result = @("SELECT DISTINCT category_name from <table name>");
While($row = @mysql_fetch_array($result) {
echo "$row[category_name]<br>\n"; // Category A, B, etc...
$result2 = @("SELECT product from <table name> where category_name = '$row[category_name]'");
While($row2 = @mysql_fetch_array($result2)) {
echo "$row2[product]<br>\n";
} //End Product Loop
} // End Category Loop

If you need any help with this one, just let me know more specifics and I'll do what I can. 🙂

John Cornett
Senior Development Engineer
Web Teks, Inc.
http://www.web-teks.com

jcornett

Forgot a close parentheses on 1 line... 🙂

While($row = @mysql_fetch_array($result) {

Changes to:

While($row = @mysql_fetch_array($result)) {

John Cornett

Anon

John Cornett wrote:

I think I know what you are trying to get done... Perhaps the code below will help:

$result = @("SELECT DISTINCT category_name from <table name>");
While($row = @mysql_fetch_array($result) {
echo "$row[category_name]\n"; // Category A, B, etc...
$result2 = @("SELECT product from <table name> where category_name = '$row[category_name]'");
While($row2 = @mysql_fetch_array($result2)) {
echo "$row2[product]\n";
} //End Product Loop
} // End Category Loop

If you need any help with this one, just let me know more specifics and I'll do what I can. 🙂

John Cornett
Senior Development Engineer
Web Teks, Inc.
http://www.web-teks.com