Titolo Colonne Tabella. Si ripetono per ogni row del data base

[fdisotto]

Basta lasciare dentro il ciclo solo l'html relativo alle varie righe, portando fuori il resto, così:

if ($result) {

echo "<table border=1>";
echo "<tr>";
echo "<th>"; echo "ID"; echo "</th>";
echo "<th>"; echo "Username"; echo "</th>";
echo "<th>"; echo "First Name"; echo "</th>";
echo "<th>"; echo "Last Name"; echo "</th>";
echo "<th>"; echo "Date of Birth"; echo "</th>";
echo "<th>"; echo "Mobile"; echo "</th>";
echo "<th>"; echo "Email"; echo "</th>";
echo "<th>"; echo "Info"; echo "</th>";
echo "<th>"; echo "Photo"; echo "</th>";
echo "</tr>";

while($row = mysql_fetch_array($result)) {

echo "<tr>";
echo "<td>"; $name = $row["$id"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$user"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$firstname"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$lastname"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$dob"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$mobile"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$email"]; echo "$name
"; echo "</td>";
echo "<td>"; $name = $row["$info"]; echo "$name

"; echo "</td>";
echo "<td>"; $name = $row["$photo"]; echo '[img]'.$name.'[/img]'; echo "</td>";
echo "</tr>";

}

echo "</table>";
}