Cant see anymore, whats wrong with this...

HooperG

I have a page that generates a table dynamicly from a query, woks great.

The header is printed out like,

for($i=0; $i<$fields_num; $i++){
$field = mysql_fetch_field($result);
echo "<th>{$field->name} </th>";
works great..

Now im trying to add a footer, and nesting two loops is kicking my but !!
before printing check to see if columb name is same as
key name in array, and if so print only the value
if not, just an empty cell

for($i=0; $i<$fields_num; $i++){
$field = mysql_fetch_field($result);
foreach ($rowsreturned as $columb =>$total){

if ("{$field->name}"=="$total"){
echo "<td>{$total->value} </td>";
} else {
echo "<td></td>";
}
}

}

Anyone know what the foolishness is ?

HooperG

ok, got the logic kinda fixed, now I cant find the nesting problem 😕

for($i=0; $i<$fields_num; $i++){
$field = mysql_fetch_field($result);
foreach ($rowsreturned as $columb =>$total){
//$fld="{$field->name}";
if ("{$field->name}"=="$columb"){
echo "<td>$total </td>"; //{$field->name}
} else {
echo "<td></td>";

                }
    }

}

tomhath

You need to echo a row of the HTML table at a time, not a column.

HooperG

Tom, did that...
Just lookin to get the last row cell by cell, and checking for its contents...

$fields_num = mysql_num_fields($result);

echo "<table id=\"builder\">";
echo "<tr>";
for($i=0; $i<$fields_num; $i++){
$field = mysql_fetch_field($result);
echo "<th>{$field->name} </th>";
}

echo "</tr>\n";
// printing table rows
$c=0;
while($row = mysql_fetch_row($result))
{
if(isOdd($c)){echo "<tr class=\"alt\">"; } else { echo "<tr>"; }
$c++;
foreach($row as $cell)
    STYLE=\"text-decoration:none\" color:#BDBDBD\">$cell</a> </td>";}
    echo "<td> $cell </td>";
echo "</tr>\n";
}