Results not diplayed using while loop

lmayer4

Afternoon,

I have this report that uses CSS and a combination fo while/if statements to diplay the data. That works like a charm---for the first row. After that no data is displayed starting on line 78. I know it has something to do with the while loop but I can't make it work!

If someone would be so good as to take a look I would greatly appreciate it.

Thanks

Laura

Riddick

Hi Laura,

It will stop displaying there because you closed your while loop there. Close your while loop after all the data that needs to be displayed.

lmayer4

Yeah the problem is that when I close the loop after the last row I get (meaning it's not grouping anymore)

row a
row b
row a
row b

intead of
row a
row a
row b
row c

I was using for($i = 0; $i < $numofrows; $i++) {
$row = mssql_fetch_array($result); instead of while but I couldn't make it iterate through the results correctly. It remembered what I wanted even though I closed the loop after the first row. However when I use while it forgets. Is there another way around this?

Thanks

Laura

tsinka

Hi,

give us an example of how the output should look like.

Thomas

lmayer4

It's supposed to look like this:

11/16/2004 |14 |1 |1
11/17/2004 |10 |1 |0
11/19/2004 |3 |1 |0
11/22/2004 |6 |1 |0
allocation

where it says allocation there should be 3 numbers under the other three but it won't display. There is data in there BTW.

Laura

lmayer4

Got it. Nevermind. It was extremely painful...