Problems with loop

[lmayer4]

Morning,

I am having problems with this loop. Instead of looping through 3 times, in this case it only goes twice. And then for the totals row it starts with the second grouping summation and puts it in the first group! I'm very confused. If anyone could shed some light that would be great. I've attached a picture just in case I'm not clear enough.

Thanks in advance

Laura

// first set some basic vars:
$i=1;
$label = "";
$total = 0;
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] <> $label)
  {
   if($total <>0)
      {  

		//totals row
			echo "<tr><td>$row[33]</td>";
			echo "<td>$row[34]</td>";
			echo "</tr>";
			 $i =0;

     }
  //table header row
echo "<tr class=header>
	    <th>Fleet Group</th>
		<th>Description</th></tr>";
   $label = $row[0];
   }

//data row
echo "<tr><td>$row[1]</td>
	  <td>$row[2]</td></tr>";

$i++;
$total++;
}

[Matt_Kindig]

First of all, I'm not sure I understand what you are using the $total and $i variables for. Your first if statement will run whenever $total is not equal to zero, i.e. for every iteration of the loop except the first. It then resets $i to zero, but it doesn't appear that $i isn't used elsewhere. It seems that you could eliminate these variables and the associated if structure, since that may be producing a problem.

Also, I'd suggesting turning all error reporting on to check for uninitialized vars, etc., that might be causing a problem. At the top of your script, add

<?php
error_reporting(E_ALL);
?>

[nemonoman]

Is this really your code? It wouldn't produce the output on the bmp.

I think you want to set $total=0 once the totals row has been echoed. Right now it's >0 every time the loop is run, which probably is one of the problems.

[lmayer4]

Okay. That sounds good. I've almost got it. I've got it to give me the correct total row for the correct group and iterate through the data. Only problem is it goes:

Header Row
Total Row

All the data

Someone is going to complain 🙂

This is the "slicked down" version so you can see it better:

// first set some basic vars:
$i=1;
$label = "";
$total = 0;
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] <> $label)
  	{
   	  //header row
		echo "<tr class=header>
		<td colspan=2>Ownership Type: ".$row[0]."</td></tr>";
		$label = $row[0];
	  //totals row
		echo "<tr class= total>";
		echo "<td colspan=2>Total:</td></tr>";
		$i =0;
	 }
   //data row
	echo "<tr class=tr>";
	echo "<td>$row[1]</td>";
	echo "<td>$row[2]</td></tr>";

$i++;
$total++;
}

echo "</table><br>";

Thanks so much for taking a look.

Laura