coordination off tables

[gvanaco]

On the picture you see the result off a sql database. you can see the numbers?

The are the result, I'll never now how much I gonne have.

I've set the border on 1 so you can see the construction of the table.

somebody advise on how I can fix this hing?

The layout is always a big mess by my?

Anny advice is welcome.

GVANACO

[LordShryku]

Maybe you should show some code, huh?

[gvanaco]

your shure?

[LordShryku]

Nah, maybe not. There's gotta be a mind reader around here somewhere. Wait for him.

[gvanaco]

This is a piece off the code

$query = "SELECT * FROM rotsen WHERE $massiefn = massief_id ORDER BY rots_naam";
$result = mysql_query($query, $mysql_access);
while($row = mysql_fetch_row($result))
{
if ($rotsn == $row[0]){
$rots_id .= "$row[0]";
$rots_naam .= "$row[1]";
$rots_beschr .= "$row[3]";
$afstand_parking .= "$row[4]";
$h_min .= "$row[5]";
$h_max .= "$row[6]";
$windroos .= "$row[7]";
$route_schatting .= "$row[8]";
$route_types .= "$row[9]";
$foto_rots .= "$row[16]";
if ($windroos == "no") ($windroos1 .= "north east"); // vertaling van de windrichtingen
if ($windroos == "o") ($windroos1 .= "east");
if ($windroos == "zo") ($windroos1 .= "south east");
if ($windroos == "z") ($windroos1 .= "south");
if ($windroos == "zw") ($windroos1 .= "south west");
if ($windroos == "w") ($windroos1 .= "west");
if ($windroos == "nw") ($windroos1 .= "north west");
if ($windroos == "n") ($windroos1 .= "north");

[gvanaco]

<?
$queryCOT = "SELECT * FROM Cot_FR WHERE Cot_FR_rotsn = $rots_id";
$resultCOT = mysql_query($queryCOT, $mysql_access);
while($rij = mysql_fetch_row($resultCOT))
{
$niveau_2 = "$rij[5]";
$niveau_3 = "$rij[6]";
$niveau_4 = "$rij[7]";
$niveau_5 = "$rij[8]";

		if ($niveau_2_tel <> 0 ){
				$prent .= "\n<td> <img src='image/grade/2.gif' alt='' width='25' height='25' border='0'> </td>";
				$bar .= "\n<td valign='bottom'> $niveau_2&nbsp; <img src='image/grade/graad.gif' alt='$niveau_2' width='10' height='$niveau_2_tel' align='bottom'> </td>";
				$spancot = $spancot + 1;
				}

		if ($niveau_3_tel <> 0 ){
				$prent .= "\n<td> <img src='image/grade/3.gif' alt='' width='25' height='25' border='0'> </td>";
				$bar .= "\n<td valign='bottom'> $niveau_3&nbsp; <img src='image/grade/graad.gif' alt='$niveau_3' width='10' height='$niveau_3_tel' align='bottom'> </td>";
				$spancot = $spancot + 1;
				}

		if ($niveau_4_tel <> 0 ){
				$prent .= "\n<td> <img src='image/grade/4.gif' alt='' width='25' height='25' border='0'> </td>";
				$bar .= "\n<td valign='bottom'> $niveau_4&nbsp; <img src='image/grade/graad.gif' alt='$niveau_4' width='10' height='$niveau_4_tel' align='bottom'> </td>";
				$spancot = $spancot + 1;
				}

$output .= "<tr>";
$output .= " $prent \n";
$output .= "</tr>";
$output .= "<tr>";
$output .= " $bar \n";
$output .= "</tr>";

}
?>

[gvanaco]

The resean off the table is that I cannot count the number off the rowspann on the begin of the creation of my table.

I have tried a few time's when I insert the include file to create a new table but I gives me a terrible layout of my page, and I don't see a way.

this is the vieuw when I create a new table

[gvanaco]

the result vieuw have to be this.

Strange, but the way that it is created is very different, but the same.

somebody some idea !!!!

your hulp, idea's, ... are very apreciated