Salve a tutti,

per favore, ho creato una semplicissima tabella:

http://www.slmty.com/

Come faccio a far apparire i titoli della tabella <th> solamente una volta. Se notate, si ripetono per ogni row del data base. ( ID Username First Name Last Name Date of Birth Mobile Email Info Photo)

Ecco il codice che uso nella pagina. Grazie mille in anticipo.


<?php
//Variables for connecting to your database.
//These variable values come from your hosting account.
$hostname = "slmty.db.10874451.hostedresource.com";
$username = "slmty";
$dbname = "slmty";

//These variable values need to be changed by you before deploying
$password = "Car4sell!";
$usertable = "members";
$id = "id";
$user = "user";
$firstname = "firstname";
$lastname = "lastname";
$dob = "dob";
$mobile = "mobile";
$email = "email";
$info = "info";
$photo = "photo";

//Connecting to your database
mysql_connect($hostname, $username, $password) OR DIE ("Unable to
connect to database! Please try again later.");
mysql_select_db($dbname);

//Fetching from your database table.
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);

if ($result) {
while($row = mysql_fetch_array($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>";

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

}
}
?>