Need help with drop down menu data selection

[outdoorxtreme1]

I want to convert the following code so that the search category will select a certain ID on MySQL and to be able to update the data on the page. I have a google map page that I only want to display a certain category at a time. I hope I explained how I am trying to get this to work ok. Any help would be great. Thanks.

<script type="text/javascript" src="/uploads/File/Javascripts/new_window_max.js"></script>
<script src="http://maps.google.com/maps?file=api&v=1&key=<? echo $GoogleAPIKey;?>" type="text/javascript"></script>

<table>
<td><select name="searchCategory" class="selectBoxes">

<option value="hikes">Hiking</option>
<option value="paddles">Canoe/Kayaking</option>
<option value="atving">ATVing</option>
<option value="points_of_interest">Points of Interest</option>
<option value="camping">Campgrounds</option>
</select></td>

<td><select name="radius" class="selectBoxes">

<option value="20">20 miles</option>
<option value="30">30 miles</option>
<option value="40">40 miles</option>
</select></td>

<td><select name="centerPoint" class="selectBoxes">

<option value="44.9742¦-74.6627">Warren, OH</option>

</select></td>
</tr></form>

<tr><td>
<a href="javascript:document.updateMapForm.submit();"><img src="/uploads/images/clickToUpdateMap.gif" border="0" name="clickToUpdateMap" onmouseover="imageRoll(this);" onmouseout="imageOut(this);"></a>
</td></tr>
</table>

<script type="text/javascript">
//<![CDATA[

// Global Variables
// set map variable
var map = "";
//set up array of locations
var aLocations = new Array;
// Storage for sidebar list
var listNodeContent = "";

// Create marker icon
var iconsm = new GIcon();
iconsm.iconSize = new GSize(43, 63);
iconsm.iconAnchor = new GPoint(21, 63);
iconsm.infoWindowAnchor = new GPoint(21, 15);

var map = new GMap(document.getElementById("map"));
// Map type: map, satellite, hybrid
map.setMapType(map.getMapTypes()[0]);
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GScaleControl());
// Center the map to the default location
map.centerAndZoom(new GPoint(-79.89505, 40.85708), 10);

// CREATES A MARKER WHOSE INFO WINDOW DISPLAYS THE GIVEN NUMBER

function createMarker(point, number, iconsm)

{
var marker = new GMarker(point, iconsm);

// SHOW THIS MARKERS INDEX IN THE INFO WINDOW WHEN IT IS CLICKED

var html = number;
GEvent.addListener(marker, 'click', function() {marker.openInfoWindowHtml(html);});
return marker;
};

<?
$link = mysql_connect("$host", "$user", "$password") or die("Could not connect: " . mysql_error());
mysql_selectdb("$database",$link) or die ("Can\'t use server : " .mysql_error());
$result = mysql_query("SELECT * FROM wholocations",$link);
if (!$result)
{
echo "no results ";
}
while($row = mysql_fetch_array($result))
{
?>
var point = new GPoint(<? echo $row['lon'] . "," . $row['lat'];?>);
var footerHtml = "<div id=\"MapBuilderIWFooter\"><h1><a href=\"#\" onclick=\"ZoomMapTo(0)\">Zoom To</a></h1></div>";
// Define Marker
iconsm.image = "http://www.somesite.com/map/images/marker_20_<? echo $row['colour'];?>.png";
var InfoHTML = "<br><? echo $row['desc'];?><br>Latitude:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<? echo $row['lat'];?><br>Longitude:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<? echo $row['lon'];?><br><? echo '<a href=\"javascript:void(0);\" onclick=\"fullScreen(\'/index.php?page=TESTPOP&trip=',$row['id'],'\');\">Click for details</a><br>';?>"

var marker = createMarker(point, InfoHTML, iconsm);
map.addOverlay(marker);
<?
}
mysql_close($link);
?>

//]]>
</script>

[edited by: dreamcatcher at 9:17 pm (utc) on Aug. 7, 2006]
[edit reason]
[1][edit reason] Generalized url. See TOS [webmasterworld.com] [/edit] [/edit][/1]

[jatar_k]

what part of it is giving you trouble?