Group results by field data ... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

pepe_lepew1962 · 01-07-2011, 11:32 PM

Code:

Hello, I am having problems with grouping records while showing the group data only once.  I am trying to get them in a html table that would look like:

+------------------------+----------------------+------------------------+
| tblTable1.fldField1    | tblTable1.fldField2  | tblTable1.fldField3    |
+------------------------+----------------------+------------------------+
| 12653                  | PBXL                 | 396.52                 |
|                        | ABCD                 | 426.28                 |
|                        | GEDL                 | 385.20                 |
+------------------------+----------------------+------------------------+
| 12654                  | ABCD                 | 515.18                 |
|                        | FGHL                 | 520.00                 |
+------------------------+----------------------+------------------------+
| 12659                  | PBXL                 | 612.35                 |
|                        | FGHL                 | 619.20                 |
|                        | XTRL                 | 420.39                 |
+------------------------+----------------------+------------------------+


<?php
//
require("connect.php");
//
$mydata101 = "SELECT tblTable1.fldField1 as 'group', tblTable1.fldField2, tblTable1.fldField3 as 'name' FROM tblTable1 GROUP BY tblTable1.fldField1";
$mydata102 = mysql_query($mydata101);
//
//
$group = null;
while($row = mysql_fetch_array($mydata102))
   {
        if($row['group'] != $group)
        {
            echo $row['group'];
            $group = $row['group'];
//
            $row['name'];
//
        }
//
    } 
?>


Any help would be great appreciated.

after_me · 01-12-2011, 05:01 AM

Did you tried GROUP BY ?

jalicia18 · 01-23-2011, 11:59 PM

Is this what you're looking for?

Quote:

$sql = "Select a.fldField1, a.fldField2, a.fldField3 FROM tblTable1 a GROUP BY a.fldField1";
$query = mysql_query($sql);
while($result = mysql_fetch_array($query))
{
echo "Field1 Name 1: " . $result['fldField1'] . "<br/>";
echo "Field1 Name 2: " . $result['fldField2'] . "<br/>";
echo "Field1 Name 3: " . $result['fldField3'] . "<br/>";
echo "<br/>";
}