Forum Moderators: open
mysql_select_db("user_quicklinks", $con);
$result = mysql_query("SELECT * FROM quicklinks ORDER BY lastname");
echo "<table border='1'>
<tr>
<th>First Name </th>
<th>Surname </th>
<th>Username </th>
<th>Website One </th>
</tr>";
// fill box with data
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['website1'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>