while and do..while?

claire

I'm using a simple while loop in my script. The while loop will execute the statement repeatedly, as long as the while expression evaluates to TRUE. The value of the expression is checked each time at the beginning of the loop, so even if this value changes during the execution of the statement, execution will not stop until the end of the iteration. Because the way the while loop works I'm getting an extra indexing in my array, which blows the rest of the script.

 while ($row[] = mysql_fetch_array ($svar)){
}

I tried to change it to a do{ } while loop instead where the evaluation is made at the end of the loop. But didn't get it right.

Any suggestions?

zmola

maybe try...

while ($row = mysql_fetch_array ($svar)){
}

claire

Originally posted by zmola
maybe try...
while ($row = mysql_fetch_array ($svar)){
}
[/B]

Need that in order to get the rest of the script working

while ($row[] = mysql_fetch_array ($svar)){
}

foreach($row as $person)
{$name = $person['surname'];
$pair = $person['Andel'];
$persons[$pair][]=$name;
}
foreach($persons as $k=>$v)
$persons[$k]=join(', ',$v);
$persons = array_values($persons);

philipolson

I'm having trouble understanding exactly what's going on but it seems like a lot of extra code exists here ... just do what you need to do inside the while loop. Btw, mysql_fetch_array will fetch both numerical and associative versions of your data so that foreach statement will contain duplicate data. Choose either mysql_fetch_row, mysql_fetch_assoc or use the optional second parameter in the mysql_fetch_array function.

claire

This is the only way I have managed to get it to work...sigh

The whole idea is to get a list of names out of a table, and before creating the array with names, pairing some of the up. The pairing up depends on whether they have a certain number in common ('Andel') or not.
(The resulting array $persons is then used further down in the script

I have so far not managed to do that within the while loop.)

The result: http://www.brfskalen11.org/claire/test5.php

philipolson

Just another version, try:

while ($row = mysql_fetch_assoc ($svar)) {
	$persons[$row['pair']][] = $row['surname'];
}
foreach($persons as $k => $v) {
	$persons[$k] = join(', ', $v);
}

$people = array_values($persons);

Yeah, while($row[] = mysql_fetch_assoc($result)); will add an extra array element with the value of boolean false. I've tried this method a few times in the past :-)

claire

Thanks! That cleans up the code and works better!
And step by step I'm learning more....

michael

I always used while (FALSE != ($line=mysql_fetch_array($r, MYSQL_ASSOC)) {

I hope this helps.