hello nairalanders,
i am working on a php/mysql project and right now i am stuck and need help fast.
what i want to do is echo out a row with 2ⁿ cells what i mean is:
row1 wld have 2 cells
row 2 wld have 4 rows
row 3 wld have 8 rows etc. You get?

my php codes are :
<?php
echo "table border=1>";
require_once "connector.inc" - # for the connector strings
require_once "tree.inc" - # for the mysql commands which is just a normal MySQL SELECT query
if($result=mysql_query($sql)){
while($row=mysql_fetch_assoc($result)){
$count=1; - # to initiate the count for the number of cells i want
echo "<tr>";
$ab =pow(2,$count); - #to limit the number of cells per row
$i=1;
do{
echo "<td>";
echo $i;
$studentname=current($row);
echo $studentname;
echo "</td>";
}
i++;
echo "</tr>";
}
}
}
echo "</table>";

I have tried to find out what i am doing wrong but i don;t seem to get it.
I wld love to use OOP but right now, i am still studying it.

Thanks alot for ur help

Why don't you also paste the respective source codes of "connector.inc" and "tree.inc" that we can follow everything step by step.

I see 2 issues with your problem:

1) First problem could be solved if you viewed source, copied and pasted the source table, and pasted it here for us to see what you are getting.

2) Looking at your code, I don't see any "colspan" which will ensure that the table layout looks good, regardless of number of cells.

2a) First thing that needs to be done, IMHO, is to draw out the table first, as though you were doing just html:

<table>
<tr>
<td colspan="4">bla</td><td colspan="4">bla</td>
</tr>
<tr>
<td colspan="2">bla</td><td colspan="2">bla</td><td colspan="2">bla</td><td colspan="2">bla</td>
</tr>
<tr>
<td>bla</td><td>bla</td><td>bla</td><td>bla</td>
<td>bla</td><td>bla</td><td>bla</td><td>bla</td>
</tr>
</table>

2b) Then you can start devising logic to accomplish this aim
2c) You will need another variable, counting down (4, 2, etc), that will dynamically populate in the "colspan"

Out of curiosity, why must the number of cells be raised by a power of 2? Seems like it is making the whole thing more complex than it should be.

good luck!

@yawa-ti-de,
thanks but i don't tink that mite fit into what i have in mind.
my intention is to dynamically generate a multi level pyramid just like that of regular mlm boards.

do u have any other suggestions that mite be of help?

I guess it depends on what an mlm board is

Well, @jeshurun07 - I posted what I believe is a possible solution to the issue you raised, but it appears it has been deleted/blocked (whatever) for some reason.

Too bad.

@jeshurun07 - I have sent a sent solution to you via email.

thx xanadu,
i saw ur mail. worked but i have to finetune it a bit to suit wot i want
thx alot anyway.

xanadu:
As moderator I can see your solution and have forwarded your post to seun to "un spam" it. Sorry for any inconveniences.

jeshurun:
based on what he sent you via email, isn't it the same thing I said above? oh, I see, it is because unlike xanadu, I didn't write actual php right? Sometimes, you have to start with pseudocode, understand that, then proceed with actual code

Thanks, @Yawa.

Well @Jesurun07 I'm glad that worked for you.

Of course, I did not expect you to use the code 'as is' - you will always NEED to fine-tune it to suit your needs!

it is really painful when you take your time to make a world class composition
only to post it and see it only in your recent posts.

maybe seun show remove his custom antispam script since from my view, isn't really working.
well, it's working just that it's doing exactly what it's not supposed to do.

Seun will never ever never ever sack the hardworking spam bot.