function view_ajax(){ global $MySQL_DB; $ret_val = ""; if ($_POST['LName'] <> '') { $query = $_POST['LName']; $result = db_access($MySQL_DB, "SELECT LastName FROM Contacts where LastName LIKE '%$query%' GROUP BY LastName ORDER BY LastName"); } if ($_POST['FName'] <> '') { $query = $_POST['FName']; $result = db_access($MySQL_DB, "SELECT FirstName FROM Contacts where FirstName LIKE '%$query%' GROUP BY FirstName ORDER BY FirstName"); } if ($row = mysql_fetch_array($result)) { do { $ret_val .= '<LI>' . $row[0] . '</LI>'; } while ($row = mysql_fetch_array($result)); echo '<ul>'.$ret_val.'</ul>'; }}