array display

[codeace]

Hi,

The code currently displays database out put in this format.

GroupName : Flower
rose
petal

GroupName : Animal
goat
cow

I would like to display a field group result at the end of each group.

Thus:

GroupName : Flower
rose
petal
Results

GroupName : Animal
goat
cow
Results

How can I do this? Its just a display thing.

$sql ="SELECT DISTINCT $dbtable.serial_value,$dbtable.type,$$dbtable.group_id,$dbtable.results,table.name,$table.nr,$table.normals,$table.msr_unit  FROM $dbtable INNER JOIN $table ON $dbtable.group_id = $table.group_id WHERE  $dbtable.job_id = '$batch_nr' ORDER BY group_id DESC";
$res = mysql_query($sql) or die(mysql_error());

while ($rows = mysql_fetch_assoc($res)){


if ($rows['group_id'] != $lastgroup) {
// Print Group Name
echo "<tr>
        <td colspan=3 align=left><strong>GroupName: ".$rows['group_id']."</strong></td>
      </tr>\n";
}

   echo "<tr>
            <td width=50>&nbsp;</td>
             <td width=200 height=25 align=center>".$rows['name']."</td><tr>";

  $lastgroup = $rows['group_id'];

}

[jkurrle]

What kind of results do you want to display? $dbtable.results? If so, what is it and is it linked to the rest of your data by group_id as well?

[codeace]

What kind of results do you want to display? $dbtable.results? If so, what is it and is it linked to the rest of your data by group_id as well?

Yes,

$dbtable.results should be displayed at the bottom of each group.It is a field of type text and it is linked to the rest of my data by group_id.

I've worked on it a bit. It now displays thus (see below) but the $rows['results'] only
shows for on one loop below the wrong group.

$cols=1;
$x = 0;

while ($x++ < $cols)
{ 
// Set initial group values
$lastgroup = '';
  // <--- muved inside the while loop

$sql ="SELECT DISTINCT $dbtable.serial_value,$dbtable.type,$dbtable.group_id,$dbtable.results,$table.name,$table.nr,$table.normals,$table.msr_unit  FROM $table INNER JOIN $dbtable ON $dbtable.group_id = $table.group_id WHERE  $dbtable.job_id = '$batch_nr' ORDER BY group_id DESC";
$res = mysql_query($sql) or die(mysql_error());


while ($rows = mysql_fetch_assoc($res)){




		//New Group Name
		if ($rows['group_id'] != $lastgroup) {


			//Display last subtotal if not first group
			if ($lastgroup) {
				echo "<tr>
						<td width=\"50\">&nbsp;</td>
						<td width=\"200\" height=\"25\" align=\"center\">Results</td>
						<td width=\"200\" height=\"25\" align=\"center\">".$rows['results']."</td>
						 <td width=\"200\" height=\"25\" align=\"center\">$subtotal</td>
					  </tr>";
			}

			//Reset the subtotal
			$subtotal = 0;

			//Print the group name
			echo "<tr>
					<td colspan=2 align=left><strong>Group: ".$rows['group_id']."</strong></td>
				  </tr>\n";
		}

        if ($rval[$counter] != $jack)
		{	
		//Display the record
		echo "<tr>
				<td width=50>&nbsp;</td>
				<td width=200 height=25 align=center>".$rows['name']."</td>
				<td width=200 height=25 align=center>".$rval[$counter]."</td>
			  <tr>";
	  }
		//Add to subtotal
		$subtotal++;

		//Set the lastgroup value
	 $lastgroup = $rows['group_id'];
	    $counter++;
	}

	//Show the last subtotal row
	echo "<tr>
			<td width=\"50\">&nbsp;</td>
			<td width=\"200\" height=\"25\" align=\"center\">Results</td>
			<td width=\"200\" height=\"25\" align=\"center\">".$rows['results']."</td>
			 <td width=\"200\" height=\"25\" align=\"center\">$subtotal</td>

		  </tr>";

		}

echo "</table>\n";	 

[codeace]

Am sure its something small in the code.