Add title to column

vjg

I have a script, which you can see below, with an output in a TABLE. It has a couple of columns.

I would like to have a title at top of a column so people know what is being showed in the column.

 
echo "<TABLE BORDER=1 CELLPADDING=3>"; 
while ($row = mysql_fetch_array($res)) { 
echo "<TR>"; 
echo "<TD>".$row[Code]."</TD>"; 
echo "<TD>".$row[Maatschappij]."</TD>"; 
echo "<TD>".$row[Vertrek]."</TD>"; 
echo "<TD>".$row[Aankomst]."</TD>"; 
echo "<TD>".$row[Consumptie]."</TD>"; 
echo "<TD>".$row[Prijs]."</TD>"; 
echo "</TR>"; 
} 
echo "</TABLE>";

Now it only shows the results. Putting in the title between " and <TD> will loop the title instead of showing it ones.

azunoman

Use the <tr><th>your header</th></tr>.

th = table header

I would however question why you would echo a table. I used to do this when first starting, but my findings is that enclosing php within html works alot better espeically later on when you want to use CSS and programming ide's that can display the html table, like Dreamweaver.

mazsolt

echo "<TABLE BORDER=1 CELLPADDING=3>";

echo "<tr><td>header1<td/><td>header2<td/> <td>header3<td/><td>header4<td/><td>header5<td/>
<td>header6<td/> </tr>";
while ($row = mysql_fetch_array($res)) {

......

if you wish to use the original headers from your mysql table:

echo "<TABLE BORDER=1 CELLPADDING=3>";

echo "<tr>";
for($i=0;$i<6;$i++)
echo "<td>" . mysql_field_name($res,$i) . "</td>";
echo "</tr>";
while ($row = mysql_fetch_array($res)) {

......

bubblenut

Well, you know what the column names are going to be before you pull them out so we don't have to get too clever really. Just place the titles outside of the the loop.

<?php
echo("<TABLE BORDER=\"1\" CELLPADDING=\"3\">".
  "<tr><td>code</td>\n".
  "<td>Maatschappij</td>\n".
  "<td>Vertrek</td>\n".
  "<td>Aankomst</td>\n".
  "<td>Conumptie</td>\n".
  "<td>Prijs</td></tr>\n");
while($row=mysql_fetch_array($res)) {
  echo("<tr><td>".$row['Code']."</td>\n".
    "<td>".$row['Maatschappij']."</td>". 
    "<td>".$row['Vertrek']."</td>".
    "<td>".$row['Aankomst']."</td>". 
    "<td>".$row['Consumptie']."</td>".
    "<td>".$row['Prijs']."</td>".
    "</>");  

}
echo("</table>");
?>

However, we could be clever and do it like this.

<?php
$table='<table border="1" cellpadding="3"><tr>';
$field_c=mysql_num_fields($res);
for($i=0;$i<$field_c;$i++) {
  $table.='<td>'.mysql_field_name($res,$i).'</td>';
}
$table.='</tr>';
while($row=mysql_fetch_row($res)) {
  $table.='<tr>';
  for($i=0;$i<$field_c;$i++)
    $table.='<td>'.$row[$i].'</td>';
  $table.='</tr>';
}
$table.='</table>';
?>

With the second method you can add fields to the query and the script will automatically change the dynamics of the table, making your script that little bit more dynamic. This kind of idea can come in very handy when you start building dynamic queries because there is rarely any way of predicting what the output will look like before you get it.
HTH
Bubble

vjg

Thank you all for the replies...

Will also try other script which were given...