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>";

[gardnc]

echo "<tr>";

echo "<td>" . $record++ . ") " . $row['Firstname'] . "<br>" . $row['Lastname'] . "</td>";

echo "<td>" . $row['Age'] . "</td>";
echo "</tr>";

[Dysan]

Cheers, M8!

One last thing, the "Sex" field contains the persons sex/gender using the following format:

• Male

• Female

How do I display just the 1st character of this field, instead of the whole word?

[gardnc]

Look up PHP's substr function

[roscor]

Your cross posting, try to keep questions separate and don't double post!