Complex while loop

jc94062

I have the following...

<td>$columns[0]</td>
<td>$columns[1]</td>

and so on, followed by

and so on, followed by

$myrow["$columns[0]"],
$myrow["$columns[1]"],

Its displaying results in a table format from a mysql db...

The top number required is kept in a variable, $nf, now currently the lists I have go up to 35, so even if it only needs to be 3, my table has 35 columns...

Can someone tell me how to sort this and to use a while loop like below...

$list = 0;
while ($list < $nf) {
//display whatever up to $nf
}

to display only the number of results I want,
ie if $nf = 1, only the pieces of code are required, if its 2, then

<td>$columns[2]</td>

$myrow["$columns[2]"],

are added on.

I hope that makes sense, please, can anyone help me!

Thanks

spider_man

Couldn't get it 100% but have you tried by limiting your query?

jc94062

Nope thats not it :-(

I did have an idea which I've been able to use for the first part that may make it clearer...

echo "<tr>";
$list = 0;
while ($list < mysql_num_fields($fields)) {
$columns[$list] = mysql_field_name ($fields, $list);
echo "<td>$columns[$list]</td>";
$list++;
}
echo "</tr>\n";

instead of

echo "<tr>
<td>$columns[0]</td>
<td>$columns[1]</td>
<td>$columns[2]</td>
<td>$columns[3]</td>
<td>$columns[4]</td>
<td>$columns[5]</td>
</tr>\n";

Thanks!

Anon

why not use a for loop?

jc94062

How do you mean?

Can you give me an example of how that would work, if $nf = 2, I'd want to output

$myrow["$columns[0]"],
$myrow["$columns[1]"],
$myrow["$columns[2]"]

if $nf = 1, I want to output

$myrow["$columns[0]"],
$myrow["$columns[1]"]

How can I do that?!

Thanks

spider_man

for ($i=0; $i<=$nf; $i++)
echo <td>$myrow["$columns[$i]"]</td>;

Note that a formated string is not needed here and so the echo statement makes a performance improvement.

jc94062

Well that improves it, but still doesn't sort out the other main problem because, and I should have mentioned this before, the
<td>%s</td> and $myrow["$columns[0]"], parts are all in a

do {

printf...

}

while (
//stuff
);

type loop.

The $myrow["$columns[0]"], and so are are also complicated because the last one in the list can't have a comma.

Well, I think this is even more complicated than I first thought :-(

jc94062

Redid the whole lot and changed the while loop to emcompess

for ($list=0; $list<=$nf; $list++)
$column[$list] = $myrow["$columns[$list]"];

echo "<tr>";
for ($list=0; $list<=$nf; $list++)
echo "<td>$column[$list]</td>";
echo "</tr>";

which works.

Thanks for the heads up :-)