<?php
mysql_connect ("localhost","monkey","monkey") or die ("could not
connect");
mysql_select_db("dbtest") or die ("could not find db");
$output = '';
// collect
if (isset($_POST['search'])) {
 $searchq = $_POST['search'];


 $query = mysql_query("SELECT * FROM accounts WHERE LNAME LIKE '%$searchq%'") or die("Could not search.");
$count = mysql_num_rows($query);
 if($count == 0) {
  $output = 'No results found.';
} else {
echo"<table border ='1'>";
echo"<tr><td>First Name</td><td>Last Name</td><td>Email</td><td>Phone</td>
 </tr>";
 while($row = mysql_fetch_array($query)) {
 echo"<tr><td>{$row['FNAME']}</td><td>{$row['LNAME']}</td><td>
{$row['EMAIL']}</td><td>{$row['PHONE_NUMBER']}</td></tr>";


 }
 echo"</table>";
 }
}
?>

echo "<tr><td>{$row['FNAME']}</td><td>{$row['LNAME']}</td><td><a href="mailto:{$row['EMAIL']}">{$row['EMAIL']}</a></td><td>{$row['PHONE_NUMBER']}</td></tr>"