Display Data on Next Line (Table)

[Dysan]

Hi.

 

The following code, displays each record in an individual column.

How do I display "Firstname" and "Lastname" in the same column, with "Lastname" on a new line?

 

$result = mysql_query("SELECT * FROM People");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
</tr>";
$record = 1;
while($row = mysql_fetch_array($result))
{
  echo "<tr>";
  echo "<td>" . $record++ . ") " . $row['Firstname'] . "\n</td>";
  echo "<td>" . $row['Lastname'] . "</td>";
  echo "<td>" . $row['Age'] . "</td>";
  echo "</tr>";
}
echo "</table>";

[bwochinski]

echo "<tr>";
echo "<td>
<span>" . $record++ . ") </span>
<span>
<div>" . $row['Firstname'] . "</div>
<div>" . $row['Lastname'] . "</div>
</span>
</td>";
echo "<td>" . $row['Age'] . "</td>";
echo "</tr>";

 

didn't test the layout, but I think that'll make it work nicely...

[Dysan]

Can it be done without the use of span? As span only works on IE? - Doesn't It

[AndyB]

How do I display "Firstname" and "Lastname" in the same column, with "Lastname" on a new line?

 

Perhaps I don't understand the question, but using an html break would do what you want.