I am still fairly new at writing php code... I am trying to write the table to show the email address as being linkable as mailto:. When I try to place this infront of the $email (4th line from the bottom) it does not display the information... Any idea of a quick fix!. Thanks in advance.
John
<?php
// open the connection
$conn = mysql_connect("localhost", "STuser", "");
// pick the database to use
mysql_select_db("hrbc",$conn);
// create the SQL statement
$sql = "SELECT * FROM email ORDER BY lname,fname";
// execute the SQL statement
$result = mysql_query($sql, $conn) or die(mysql_error());
//go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$id = $newArray['ID'];
$fname = $newArray['fname'];
$lname = $newArray['lname'];
$email = $newArray['email'];
// echo the results on screen
echo "<TR>";
echo "<TD><CENTER>$fname $lname </font></CENTER></TD>";
echo "<TD><CENTER>$email</CENTER></TD>";
echo "</TR>";
}
?>
