Trying to write a table...

akoss11

Hi,

I'm trying to write a php page that will show the results from my query in a table 2 cols x say 3 rows.

I figured to get the results looking the way I want them, I should fill the table one row at a time.

I've been fiddling all weekend and trying mysql_fetch_row and mysql_fetch_array but can't seem to figure how to have a loop that will take the first two rows of results and then allow me to close the <TR> and then extract the next two rows....

I'm sure we're missing something obvious here.... I can post some of the code we are using if it will help....

Thanks in advance,
Akoss

bastien

🙂

akoss11

This morning I found a way of doing it.... I don't know if there's a cleaner way.... also, something is wrong with the while towards the bottom of the code.... it does do what I want, but it is clearly not correct (even to me!)

echo "<table border='1' width='600'>";
while ($data=mysql_fetch_array($result))
{
for ($count=0;$count <1;$count++)
{
echo "<TR><TD>";
echo $data[0]." ";
echo $data[1]." ";
echo $data[2]." ";
echo $data[3]." ";
echo $data[4]." ";
echo $data[5]."";
}
echo "</td><TD>";

if ($data=mysql_fetch_array($result))
{
do {
echo $data[0]." ";
echo $data[1]." ";
echo $data[2]." ";
echo $data[3]." ";
echo $data[4]." ";
echo $data[5]."";
} while ($count < 1);
echo "</td></tr>";
}
}

jeremuck

I'm not sure what you are trying to do.

Generally, to present a table from some database results, you use two loops:

The first loop does each row.
The second loop does each column.

The row represents a single record from the database.

The columns represent each field.

Look around for examples.
I have a function that will do it posted in
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10212370

If you want extra things done, you add the complexity inside the loops.