Counter counts backwards

Anon

Well I'm at a loss for this, so I'm hoping it's one of those easy things that I just glanced over too quickly in the manuals.

I use a PHP page to search a SQL database for football games. I used mysql_num_row($results) to get a list of how many rows there are, and then count down to 0, at which time a if() statement does some funky stuff (ending the results list).

Unfortunately, for some reason, when the counter gets down to 4, it skips to 2 and then back up to 3. I had it printout my results to demonstrate.

6Tulsa v. Morehead St.
5South Florida v. Northern Illinois
4Arizona v. San Diego St.
2Idaho v. Washington St.
3Navy v. Temple

This is the relevant code:

$num = mysql_num_rows($result);

while loop (blah blah blah)
{
$num = $num-1;
if ($num < 1) {
echo $Finished;
}
}

I've tried ==1, <=1, etc to no avail. I've changed around the order of display (from first team to second team) but still same result.

Any ideas?

mithril

Andrew,

Why use the counter in the first place? Simply do this:

 while ($myRow = mysql_fetch_array($result)) {

   // print the result row

 }

 // all rows are printed, we know we're finished, do the funky ending stuff

I'm guessing that will do what you want, and it's much simpler. HTH.

Geoff A. Virgo

Anon

I'll give that a try when I wake up. I tried something like that last night to no avail as I'm not really printing in between the { } but saving everything to a string, $output and then fwrite-ing $output to a file. I though (last night) that I could fwrite everything to a file within the { } and then fwrite the last snippet separately, but that didn't work. I'll try playing with that again as I might have had the second fwrite in the wrong place.

Anon

Basically here is what I have
$header = whatever1
$footer = ""

while($line = mysql_fetch_array($result)){
extract($line);

blah-blah-blah

$output=$header$body$footer;
$filename = "ncaaf.js";
$fp = fopen($filename,"a+");
fputs($fp, "$output");

$header = "" // gets rid of the header after 1st pass.

}

That's the basic code. I added a counter to count down the number of rows and when $rows == 0 I would then change the $footer = "whatever2"

Could I a) put a second fopen command to append the footer after all the while{} loop content is written or b) nest a while{} loop that would keep the value of $footer at "" until it is 'done' and then change the value of $footer to "whatever"?

I guess I'm a little uncertain where to write the $footer.