On Sun, May 6, 2012 at 12:38 AM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> wrote:
> I have a discrepancy in the number of elements in my arrays and can't see
> why.
>
> Here is some code:
> Note the lines with the ***
>
> *** $plyrs = 0;
> unset($plyrnames_ar);
> unset($js_names);
> unset($js_seeds);
> *** $rows = mysql_num_rows($qrslts);
> ***echo "in mysql there are $rows rows<br>";
> while ($row = mysql_fetch_array($qrslts))
> { // build the name value here
> $mi = ($row['MI']=='') ? '' : " ".$row['MI'];
> $nm = $row['LastName'].", ".$row['FirstName'].$mi;
> if ($row['srtdbls']=='X')
> {
> $mi = ($row['partMI']=='') ? '' : " ".$row['partMI'];
> $nm .= "/".$row['partLN'].", ".$row['partFN'].$mi;
> }
> *** $plyrs++;
> $plyrnames_ar[$nm] = $row['Draw_pos'];
> }
> *** echo "before sort there are ".count($plyrnames_ar)." in
> plyrsnames_ar<br>";
> ksort($plyrnames_ar);
> foreach ($plyrnames_ar as $nm=>$sd)
> {
> $js_names[] = $nm;
> $js_seeds[] = $sd;
> }
> *** echo "plyrs is $plyrs and there are ".count($js_names)." entries in
> js_rnames and ".count
> ***($plyrnames_ar)." entries in plyrnames_ar and ".count($js_seeds)." in
> js_seeds";
> exit();
>
> The problem is that my $plyrs field comes up 18, while in truth there are
> only 17 rows of data in my database.
> All of the other array-size counts echo out as being only 17, but my $rows
> and $plyrs fields come up as 18. I was having problems with my javascript
> showing an undefined array element and took a bit o time to determine what
> it was and where it was happening.
>
> Questions - does mysql_num_rows return a extra row that somehow doesn't get
> processed in the while loop? And if it does how come the counter ($plyrs)
> that I put into the loop comes up higher than it should.?
>
>
My guess would be that you end up with 2 rows having the same $nm,
overwriting the value that's already in $plyrnames_ar.
- Matijn
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
