looping question...

[richie]

I need help with looping within another loop.

$num = mysql_num_fields($result);

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

for($i=0; $i<$num; $i++){
echo $row[$i] . "\t";
}
}

The FOR loop only prints the value for $row[0] and exits.

My question is, how can I get the FOR loop to run completely for every iteration of the WHILE loop?

tia,
Richie.

[bad76]

Hi,
i think your code good.
I can look the query? Select you multiple field (like select * from...)?

[edit]
For debug it you can output $num before while...
[/edit]

[richie]

I didn't show the mysql query. I'm only concerned about the looping part of the code.

[bad76]

:mad:
ok, but what about this?

$num = mysql_num_fields($result);
echo $num;
while($row = mysql_fetch_array($result)){

[richie]

$num = 64;

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

for($i=0; $i<$num; $i++){
echo $row[$i] . "\t";
}
}

In the above, the FOR statement is supposed to loop 64 times for every iteration of the while statement. Unfortunately, it only loops once.

I hope my question is clearer now.

[laserlight]

What is the query sent?
It looks like you do indeed only have 1 column returned.

[richie]

The query is
select * ...

db table has 64 columns.

This works...

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

echo "$row[0]\t$row[1]\t$row[2]\t..... up to $row[63]\t";

}

But this returns only outputs one column per iteration...

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

for($i=0; $i<$num; $i++){
echo $row[$i] . "\t";
}
}

[ahundiak]

Your code looks right. Are you sure you are not accidently changing the value of $num or $i? You are not using a function with $num being out of scope? And you are sure that the other 63 columns have some data?

Try
for($i=0; $i<$num; $i++){
echo $num . ' ' . $i . ' ' . $row[$i] . <br />;
}

Just to confirm what your loop variables are doing.

[tekky]

This will print all the values from each ROW.... which I think you are wanting...

while($row = mysql_fetch_array($result, MYSQL_NUM)) // or you can use mysql_fetch_row($result)
{
     for($i=0; $i<sizeof($row); $i++)
     {
          echo $row[$i] . "\t";
     }
}

using sizeof() will ensure you display ALL the contents of the row...

HTH 😉

note: and if your select is anything like "SELECT * FROM table WHERE x=y" then of course you will only have ONE iteration 😉

[seby]

count() will do the samething..

[csousley]

You could also just take the while loop out of it. Maybe something like this:

$num = mysql_num_fields($result); 

for($i=0; $i<$num; $i++){ 
$row = mysql_fetch_array($result);
$whatever = $row['whatever'];
echo $whatever;
} 

Just a thought??? Good Luck!

[tekky]

Originally posted by seby
count() will do the samething..

yes it will... however he wasnt using count() either 😉

guess now he has 2 options for that 🙂