Thank you.
Priya
Here is my HTML code:
Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<h3>Search Contacts Details</h3>
</head>
<body>
<p>You may search based on Lastname.</p>
<form action="UserInformationSearch.php?go" method="post">
<p><a href="?by=A">A</a> | <a href="?by=B">B</a> | <a href="?by=C">C</a> | <a href="?by=D">D</a> | <a href="?by=E">E</a> | <a href="?by=F">F</a> | <a href="?by=G">G</a> | <a href="?by=H">H</a> | <a href="?by=I">I</a> | <a href="?by=J">J</a> | <a href="?by=K">K</a> | <a href="?by=L">L</a> | <a href="?by=M">M</a> | <a href="?by=N">N</a> | <a href="?by=O">O</a> | <a href="?by=P">P</a> | <a href="?by=Q">Q</a> | <a href="?by=R">R</a> | <a href="?by=S">S</a> | <a href="?by=T">T</a> | <a href="?by=U">U</a> | <a href="?by=V">V</a> | <a href="?by=W">W</a> | <a href="?by=X">X</a> | <a href="?by=Y">Y</a> | <a href="?by=Z">Z</a></p>
</form>
</body>
</html>
Code: Select all
<?php
$db = mysql_connect(localhost, 'username', 'password') or die('Error: ' . mysql_error());
mysql_select_db('DBname') or die('Could not select database');
if(isset($_GET['by'])){
$letter=$_GET['by'];
$sql = "SELECT Firstname, Lastname, Street, City, State, Zipcode, `Primary Phone`, Email FROM Tablename WHERE Lastname LIKE '" . $letter . "%'";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$firstname =$row['firstname'];
$lastname=$row['lastname'];
$str=$row['str'];
$city=$row['city'];
$state=$row['state'];
$zipcode=$row['zipcode'];
$phone=$row['phone'];
$email=$row['email'];
//-display the result of the array
echo "<ul>\n";
echo "<li>" . $firstname . " " . $lastname . "</li>\n";
echo "<li>" . $str . " " . $city . " " . $state . " " . $zipcode . "</li>\n";
echo "<li>" . $phone . "</li>\n";
echo "<li>" . "<a href=mailto:" . $email . ">" . $email . "</a></li>\n";
echo "</ul>";
}
}else{
echo "No such records found.<br/>";
die();
}
?>