Confused using while loops

lmayer4

Morning,

I can't seem to make this display like I want:

echo "<TABLE class='table'>"; while($row = mssql_fetch_row($result)) { $myArray[$row[0]] = $row[1];
 //now we expand it 

while(list($bodytype) = each($myArray)) { 
echo "<tr class=tr><td colspan=4><b>$bodytype</b></td></tr>"; //table header row 
echo "<tr class=tr><th></th></tr>"; 
//for the sake of clarity the rest of rows removed 
} 
//data row 
echo "<tr class=tr>"; 
echo "<td>$row[1]</td>"; 
//for the sake of clarity the rest of rows removed 
echo "</tr>";
//allocations row 
echo "<tr class=tr>"; 
echo "<td>Allocation</td>";
 echo "<td>$row[22]</td>"; 
//for the sake of clarity the rest of rows removed 
echo "</tr>";
 } 
echo "</table>";

This is what happens:

Specialty
MT Strip Door
06/29/2005 126 19 17
Allocation 110 12 9
06/30/2005 131 21 18
Allocation 105 12 9

What I want to happen is this:

Specialty
MT Strip Door
06/29/2005 126 19 17
06/30/2005 131 21 18
Allocation 105 12 9

I know its the brackets but I can't seem to get it right. Can anyone point me in the right direction?

Thanks so much.

Laura

halojoy

So, laura
you do not want Allocation 110 12 9 displayed
only this Allocation 105 12 9

<?php
echo "<TABLE class='table'>"; 

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

//now we expand it 

// while2 start - inside while one
while(list($bodytype) = each($myArray)) { 

//table header row 
echo "<tr class=tr><td colspan=4><b>$bodytype</b></td></tr>";
echo "<tr class=tr><th></th></tr>";  
//for the sake of clarity the rest of rows removed 

} // while2 end

//data row 
echo "<tr class=tr>";  

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

//for the sake of clarity the rest of rows removed 
echo "</tr>"; 
//allocations row 
echo "<tr class=tr>";  

echo "<td>Allocation</td>"; 
 echo "<td>$row[22]</td>";  

//for the sake of clarity the rest of rows removed 
echo "</tr>";

}  // while1 end

echo "</table>";
?>

Well, what can you do to solve this??????
😕

lmayer4

Well, what can you do to solve this??????

Darn good question 🙂

Yes I only want one row of allocations to be displayed.

I've been banging my head on the desk for days over this. I can't get to display just right. I see everything but not how I want it.

halojoy

Maybe solution
is in the hidden part --- rest of rows removed
What are you hiding for us? 😉
You shouldnt have to hide anything from friendly 'halojoy' from Sweden.

I do only see word: Allocation echo-ed 1 time.
So your while1 loop is doing it twice ( looping )

lmayer4

What are you hiding for us?

123 lines of code 🙂 I didn't want to overwhelm anyone so they wouldn't even look.

Yes, it seems to be looping twice I want it to loop through the first row [data] and then display the last rows [Allocation] and [Difference] once. (I've added the difference row but it does the same thing as allocation)

I've attached it if you'd like to see.