Group 2 subsets

lmayer4

Morning,

I posted this before but I must have been unclear. Hopefully I get it right this time.
This is how I want it to look:

Facility Name
<table>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
</table>


(next)Facility Name
<table>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
<tr><td>BodyType</td></tr>
<tr><td>data</td><td>data</td><td>data</td></tr>
</table>

There are 20 Facilities to loop through and 3 BodyTypes. I can make it do what I want except for one thing I can't get the Facility outside the table. Any thoughts would be most welcome.

Laura

maxpup979

the quick and dirty answer is...put the table tags outside of the loop.

post the code that generates this lil bit, and I have no doubt we can clear it right up. But just from the looks, Id say you have something like:

loop control on facility
table
facility name
bodytypes info/data etc
close table
close loop

so if you move facility name out of the table, it should all be fine. but this is all just guess work...🙂

post the code...🙂

lmayer4

Thanks for that here goes:

// first set some basic vars:
$label = "";
$type = "";
$data = "";
$allocation = '';
$diff = '';

include ("UpLoad/connect.php");

//load it all into the associative array
$sql = "select * from dbo.vwAllByFacility";
$result = mssql_query($sql);


echo $type;
echo "<table border=1>";
while($row = mssql_fetch_row($result)) 
{
 		if($row[1] <> $label)
		  { 
   			  if($allocation != '')
			   {
				   echo $allocation;
			   }
			   if($diff != '')
			   {
				   echo $diff;
			   }
		//header row
       	echo "<tr class=blue><td>Facility: $row[0]</td><tr>
		<TR class =dkblue>
		<th class=header>".$row[1]."</td>
		<th>MT</th><th>Strip</th></tr>";
		$label = $row[1];

    //allocations row
         $allocation = "<tr class=blue>".
         "<td>Allocation</td>".
         "<td>$row[23]</td>".
         "<td>$row[24]</td>".
         "<td>$row[25]</td>".
         "</tr>";
	//difference row
         $diff = "<tr class=blue>".
         "<td>Difference</td>".
         "<td>$row[41]</td>".
         "<td>$row[42]</td>".
         "<td>$row[43]</td>".
         "</tr>";
		} 

   //data row
        echo "<tr class=tr>
   <td>$row[2]</td>
   <td class=$mtstyle>$row[3]</TD> 
    <td class=$ststyle>$row[4]</td>
        <td>$row[5]</td>
        <td class=blue>$row[6]</td>
        </tr>";


}
echo $allocation;
echo $diff;
echo "</table><br>";

maxpup979

Let me make sure I understand what you want to do. Right now, the Facility header is in the table, as its own distinct TR, and you want it to be moved out of the table? so your structure would become multiple tables each with a Facility header?

if thats what you want, just move the table declaration into the loop, and use multiple tables.

// first set some basic vars:
$label = "";
$type = "";
$data = "";
$allocation = '';
$diff = '';

include ("UpLoad/connect.php");

//load it all into the associative array
$sql = "select * from dbo.vwAllByFacility";
$result = mssql_query($sql);


echo $type;

while($row = mssql_fetch_row($result)) 
{
 		if($row[1] <> $label)
		  { 
   			  if($allocation != '')
			   {
				   echo $allocation;
			   }
			   if($diff != '')
			   {
				   echo $diff;
			   }
		//header row
       	echo "<span class=blue>Facility: $row[0]</span>
                echo "<table border=1>";
		<TR class =dkblue>
		<th class=header>".$row[1]."</td>
		<th>MT</th><th>Strip</th></tr>";
		$label = $row[1];

    //allocations row

         $allocation = "<tr class=blue>".
         "<td>Allocation</td>".
         "<td>$row[23]</td>".
         "<td>$row[24]</td>".
         "<td>$row[25]</td>".
         "</tr>";
	//difference row
         $diff = "<tr class=blue>".
         "<td>Difference</td>".
         "<td>$row[41]</td>".
         "<td>$row[42]</td>".
         "<td>$row[43]</td>".
         "</tr>";
		} 

   //data row
        echo "<tr class=tr>
   <td>$row[2]</td>
   <td class=$mtstyle>$row[3]</TD> 
    <td class=$ststyle>$row[4]</td>
        <td>$row[5]</td>
        <td class=blue>$row[6]</td>
        </tr>";

      echo "</table><br>"; 
}
echo $allocation;
echo $diff;

is that what you were looking for?

lmayer4

Well I could have it in the table as one row as long as it showed up just once not for each bodytype (3 times). The table would have to be one for each facility not for each bodytype so I'll have to play around with the code some more.

Thanks for the help. 🙂

Laura

maxpup979

Ah...why didnt you say so?...🙂 now this makes more sense. I assume the the SP you are calling does an order by facility--all you have to do then is loop across the result set, and test each time to see if the current facility has changed. if the facility has changed, print the new facility row. I can whip up an example in just a bit...

lmayer4

Wahoo 🙂 That would be lovely. I just can't get the right combination.

maxpup979

this seems to do the trick....🙂

<?php

$arr[0]["facilityname"]="fac1";
$arr[0]["btype"]="b1";
$arr[1]["facilityname"]="fac1";
$arr[1]["btype"]="b2";
$arr[2]["facilityname"]="fac1";
$arr[2]["btype"]="b3";
$arr[3]["facilityname"]="fac2";
$arr[3]["btype"]="b1";
$arr[4]["facilityname"]="fac2";
$arr[4]["btype"]="b2";
$arr[5]["facilityname"]="fac2";
$arr[5]["btype"]="b3";
$arr[6]["facilityname"]="fac3";
$arr[6]["btype"]="b1";
$arr[7]["facilityname"]="fac3";
$arr[7]["btype"]="b2";
$arr[8]["facilityname"]="fac3";
$arr[8]["btype"]="b3";
$currfac="";
print "<table border=1>";
for($x=0;$x<count($arr);$x++){
  if(!($arr[$x]["facilityname"]==$currfac)){
  	#this is a new facility--
	if($x>0){
		#the first time through is handled a little differently.
		print "</td></tr>";
	}
	print "<tr><td>".$arr[$x]["facilityname"]."</td></tr>";
	print "<tr><td>Allocation</td>";
	#reassign currfac
	$currfac=$arr[$x]["facilityname"];
  }
  print "<td>".$arr[$x]["btype"]."</td>";
}
print "</tr></table>";
?>

maxpup979

I did use an array, but it should work about the same as your sql results

lmayer4

Neat 🙂 I'll try that.

Thanks again

Laura