Nightmare of an array

lmayer4

Morning,

I have been trying unsuccessfully to make this work. I know it is how I have the brackets but I can't seem to get it.

I want the result to look like this:

Owned
18900s trailer
284s trailer
910s trailer
Total 3

Leased
GHI trailer
PAC trailer
Total 2

What I get is:

Owned
18900s trailer
Total 1

Leased
GHI trailer
Total 1

Heres the code WAYYY trimmed down so you can see the bracket structure: The way I have it here it will only loop through once.

while($row = mssql_fetch_row($result)) 
	{
    $myArray[$row[0]] = $row[1];

//now we expand it
while(list($DEPTCODE) = each($myArray)) 
	{//table header row

		{
		//data row 

		//totals row
		}
	}
 }

Please someone help! I'm at the end of my rope here :bemused:

Laura

leatherback

Hi,

You do NOT need arrays here (He said without knowing anything about the rest).

I assume:
- You query from a database, and get for each resulting row:
a section label (e.g.: Owned )
a specification (e.g.: 18900s trailer )

then, use this setup: (Replace label and specification rows to match your setup)

// first set some basic vars:
$i=1;
$label = "";
$total = 0;

while($row = mssql_fetch_row($result)) 
{
if($row['label'] <> $label)
  {
   if($total <>0)
      {
      echo "Total: ".$i."<br>";
      $i =0;
      }
   echo $row['label'];
   $label = $row['label'];
   }
echo $row['specification']."<br>";
$i++;
$total++;
}
echo "In total we have ".$total ;

[edit]
ps: Make sure you sort your results by label!
[/edit]

lmayer4

Hmmmm very interesting 🙂 I will try it.

Thanks so much

Laura

lmayer4

Okay. I tried it and I still get one row one total thing.

I am sure I've cobbed this together incorrectly. $row[0] is the label BTW.

 // first set some basic vars:
$i=1;
$label = "";
$total = 0;
/* connect to db */
include ("TFWConnect.php");

//load it all into the associative array
$sql = " ";
$result = mssql_query($sql);
echo "<table border=1>";
while($row = mssql_fetch_row($result)) 
{

if($row[0] <> $row[0])
  {
   if($total <>0)
      {
      echo "Total: ".$i."<br>";
      $i =0;
      }
   echo $row[0];
   $row[0] = $row[0];
   }
   	/*table header*/
  	/*data row*/

/*totals row*/


$i++;
$total++;
}
echo "</table><br>";
echo "In total we have ".$total ;

leatherback

Read my post carefully.. THe comparison is between $label, and $row['label']. So ONLY change the $row[] NOT the $label variables.

lmayer4

Okay almost there!

It's displaying pretty close to what I need. The only thing is the Total row is displaying the data for the next grouping! I've attached a picture of what I mean.

Thanks so much

Laura