PHP Store Locator, need help making it look better

[Valdoua]

Hello, a few years ago a person who was on these boards helped me create a store locator for my website, www.schylling.com.

http://www.schylling.com/store_finder.php

I would like the output from the store locator look better. Right now it is really down and dirty. I have extremely little experince with PHP, the person who helped me out basically set the whole thing up for me. I would like to have it look better and if it is out dated please let me know so I can find ways to change it.

Basically it works by zip code and/or state

BUt when the consumer reads the outcome they get a list of possibles in a table.
I would like to make the outcome look more user friendly. Also is there a way to add a map funtion like google maps or mapquest to it?

Any help or crituque would be greatly appreciated.

Thanks,

Val.

[benracer]

any chance of the current script (php)?

[Valdoua]

Okay, here is the starting point of the form from http://www.schylling.com/store_finder.php

<form name="search" action="spage2.php" method="post">
<p style="margin-top: -1; margin-bottom: -1">
<font face="Verdana"><b><font size="2">Search by Zip:</font></b></font><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font>
<input type="text" name="zipCode" size="20"> <b><font size="2" face="Verdana">(example: 01922)&nbsp;
</font></b>
</p>
<p style="margin-top: -1; margin-bottom: -1">
<br>
<font face="Verdana" size="2"><b>Search by State:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</b></font> <input type="text" name="state" size="20">
<input type="submit" size="20"> <b> <font size="2" face="Verdana">(example: NY for New York) </font>
</b>
<br>
</p>
</p>
</form>

Here is the code from the second page:

</html>
<?

// Page two, search and display
$connect = mysql_connect("XXXX", "XXXX", "XXXX");

$db = mysql_select_db("schylling_storelist", $connect);

$sql = "SELECT *
FROM STOREDATA
WHERE State = '".$POST['state']."'
OR ZIP_Code = '".$POST['zipCode']."'";

$result = mysql_query($sql);

$rows = mysql_num_rows($result);

if($rows > 0) {

echo "<p><center></p>
<table border=\"1\">

<th align=\"center\newstyle\">Name</th>
<th align=\"center\">City</th>
<th align=\"center\">State</th>
<th align=\"center\">Sales Phone</th>";

while($row=mysql_fetch_array($result)) {  
    echo "<tr><center>
            <td align=\"center\" class=\"newstyle\">".$row['Name']."</td>
            <td align=\"center\" class=\"newstyle\">".$row['City']."</td>
            <td align=\"center\" class=\"newstyle\">".$row['State']."</td>
            <td align=\"center\" class=\"newstyle\">".$row['Sales_Phone']."</td>
          </tr>";  
}  

}

else {

echo "No results found";

}

mysql_close($connect); ;

As you can see this is really basic no frills.