Show table grid even if no data in cell

[lmayer4]

Morning,

I am trying to create table from a database that needs to be printed out. What happens now is the data comes out fine but the table only shows the lines if there is data in the table. Is there a way to do this so all the grid lines show up regardless?

Thanks

Laura

[slade7]

Have your script stick an   in any cells that are empty. If you are using php, it's

if(empty($foo)){
$foo = " ";
}

[lmayer4]

Like so?

mssql_data_seek ($result, 0);
while ($row = mssql_fetch_assoc ($result)) {
echo "<tr>\n";
foreach ($row as $column)
{
if(empty($column))
{
$column= "&nbsp;";
}
else
{
echo "<TD>$column</TD>\n";
}
echo "</TR>\n";
}

[Fotiman]

Like so:

mssql_data_seek ($result, 0);
while ($row = mssql_fetch_assoc ($result)) {
echo "<tr>\n";
foreach ($row as $column)
{
if(empty($column))
{
$column= "&nbsp;";
}

echo "<TD>$column</TD>\n";

echo "</TR>\n";
}

[slade7]

Fotiman is right - you want to echo it either way. All the if statement should to is set $column = "&nbsp" IF the variable $column is empty

In yours it would not echo a <TD> at all if $column is empty

[lmayer4]

Thanks so much! That works perfect. Thanks again for all the help.

Laura

[Robin_reala]

Ideally you should be able to do:

table { empty-cells: show; }

instead of adding an nbsp entity, but I've no idea what browser support is like.