Combining query results that are the same

[mchoffa]

I am trying to take a query that gives me this:

"kind": "description"
engine: gm
engine: v6
engine: 350
transmission: auto
transmission: 3 speed

and make it print out on the page like this:

engine: gm, v6, 350
transmission: auto, 3 speed

put all results that are the same "kind" and combine the descriptions together with a ", " in between them

here is the code as it is now:

        function grabfeatures($query, $featurelength){

            echo "<center><table width=\"480\">\n";

            $result = $this->ExecuteQuery($query);

            $features = array();

            while($row = $this->HashQuery($result)) {
                    $features[] = $row;
            }

            $frows = array();

            while(count($features)) {
                    $fr = array_splice($features, 0, 2);
                    array_push($frows, $fr);
            }


            foreach($frows as $frowix => $frow) {
                    echo "<tr>\n";
                    foreach($frow as $fix => $f) {
                            $kind = $f["kind"];
                            $description = $f["description"];
                            echo "<td><font face=\"verdana\" size=\"1\"><b>$kind:</b> $description</font></td>\n";
                    }
                    echo "</tr>\n";
            }

            echo "</table></center>\n";     
    }

[mchoffa]

|----|-----------|----------------|--------------|
|-id-|-carnumber |---kind---------|-description--|
|----|-----------|----------------|--------------|
|----|-----------|----------------|--------------|
|-1--|-323-------|---engine-------|-v6-----------|
|----|-----------|----------------|--------------|
|-2--|-323-------|---transmission |-auto---------|
|----|-----------|----------------|--------------|
|-3--|-323-------|---engine-------|-gm-----------|
|----|-----------|----------------|--------------|
|-4--|-323-------|---transmission |-3-speed------|
|----|-----------|----------------|--------------|
|-5--|-323-------|---engine-------|-350----------|
|----|-----------|----------------|--------------|
|-6--|-324-------|---engine-------|-v8-----------|
|----|-----------|----------------|--------------|
|-7--|-324-------|---transmission |-manual-------|
|----|-----------|----------------|--------------|
|-8--|-324-------|---engine-------|-gm-----------|
|----|-----------|----------------|--------------|
|-9--|-325-------|---transmission |-manual-------|
|----|-----------|----------------|--------------|
|-10-|-325-------|---engine-------|-v6-----------|
|----|-----------|----------------|--------------|

That is my basic table layout. Basically I call them on the page by car number, then want to show the features of that car... i want to show any engine descriptions seperated by commas, then show any transmission descriptions seperated by commas. This of course is a very simplified version for testing purposes.

[liquorvicar]

how about something like this?

$sql = "SELECT * FROM table ORDER BY carnumber,kind";
$query = mysql_query($sql,$c);
while ($result=mysql_fetch_assoc($query)) {
  $data[$result['carnumber']][$result['kind']][] = $result['description'];
}

foreach ($data as $car=>$car_array) {
  foreach ($car_array as $kind=>$kind_array) {
    echo($car.':'.$kind.':'.implode(',',$kind_array));
    echo('<br>');
  }
}