WHILE-LOOP FOR Professionals ???

jennes

Dear Members,

I`m a litle newbie and have a big question. How may i get a table-field out of mysql-database and echo it into a html-table, without using a while-loop ???

I need this because i want to create a html-table to show datas out of 2 different mysql-tables.

<TR>
<TD>1. cell left, filled with data-sqltable1</TD>
<TD>1. cell right, filled with data-sqltable2/</TD>
</TR>

<TR>
<TD>2. cell left, filled with data-sqltable1</TD>
<TD>2. cell right, filled with data-sqltable2</TD>
</TR>

Has anyone an idea to realize with or better without arrays ?????

crusty_php

A Professional charges!

First put the results into an array:

while ($row = mysql_fetch_array($result1))
{
$array1[] = $row["data-sqltable1"];
}
while ($row2 = mysql_fetch_array($result2))
{
$array2[] = $row2["data-sqltable2"];
}

for ($idx=0;$idx<count($array1);++$idx){
echo "<TR>";
echo "<TD>$array[$idx]</TD>";
echo "<TD>$array[$idx]</TD>";
echo "</TR>";

}

hope this gives you an idea

crusty_php

A professional would also get it right 😉
(missed a bit)

while ($row = mysql_fetch_array($result1))
{
$array1[] = $row["data-sqltable1"];
}
while ($row2 = mysql_fetch_array($result2))
{
$array2[] = $row2["data-sqltable2"];
}

for ($idx=0;$idx<count($array1);++$idx){
echo "<TR>";
echo "<TD>$array1[$idx]</TD>";
echo "<TD>$array2[$idx]</TD>";
echo "</TR>";

}