-Ok, this is what I have. I hope this is what you are looking for. I'm looking to format this search results page so that the results come back with the entire entry that also matches the zipcode that was searched.
ex: zipcode search = 90210
results for 90210 are:
contactname
phone number
city
date posted
etc.
AND, somehow ( I'm thinking ordered list) to have a format for multiple results sorted by date.
Is this possible?
Thanks again in advance
Michael
<html>
<head>
<title>www..com</title>
</head>
<body BACKGROUND="images/dirt.gif" text="#FFFFFF" link="#FFFFFF" vlink="#FFFF00" alink="#FFFF00" BGPROPERTIES="fixed">
<?
/* MySQL details */
$dbHost = "mysql";
$dbUser = "";
$dbPass = "";
$dbName = "";
$table = "havedirt";
/* Attempt connection to MySQL server */
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
/* If connection wasnt successful... */
if (!$link)
{
print ("<b>Error:</b> Could not connect to database.");
exit;
}
/* Attempt to select our database */
if (!@mysql_select_db($dbName))
{
print("<b>Error:</b> Could not find $dbName database.");
exit;
}
$ZipCode = "$_POST["zipcode"]";
/* Build SQL query to fetch all entries from the table */
$query = "SELECT * FROM $table WHERE zipcode = "$ZipCode";
/* Execute query */
$result = mysql_query($query);
/* If there was a problem with the query... */
if (!$result || @mysql_num_rows($result) < 1)
{
print("No entries in table $table.");
exit;
}
print("<table>");
/* For each table entry returned... */
while($row = mysql_fetch_array($result))
{
/* Add details to output variable */
print("<tr><td> . $row['zipcode'] . "</td>");
print("<tr>");
}
print("</table>");
/* Close link to MySQL */
mysql_close($link);
?>
</body>
</html>
