This should be very useful:
http://googlegeodevelopers.blogspot.com/2008/08/mapiconmaker-11-create-dynamic-flat-and.html


On 7 Okt., 19:49, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> I don't know much about google maps. in fact i found out how to use
> the google maps api just yesterday. but I have a fairly basic map
> pulling data from two different mysql databases and putting the
> markers on the map where there at. what i'm trying to do is make the
> numbers from one database blue and the markers from the others red
> while numbering the markers 1 - 99. the website that the map is on 
> iswww.josegoes.com. once there just select a state press go and the map
> I have is in the right hand menu.
>
> here's all the code I have for the map.
>
>             <script src="http://maps.google.com/maps?file=api&v=1&key=KEY -
> HERE" type="text/javascript">
>     </script>
> <?php
> while($rowx = mysql_fetch_array($xerrs))
>   {
>   $lat = $rowx['latitude'];
>   $lon = $rowx['longitude'];
>   }
> ?>
>
>     <div id="map" style="width: 300px; height: 300px; text-
> align:center;margin-bottom:10px;"></div>
>     <script type="text/javascript">
>     //<![CDATA[
>
> var map = new GMap(document.getElementById("map"));
> map.addControl(new GLargeMapControl());
> map.addControl(new GMapTypeControl());
> map.centerAndZoom(new GPoint(<?php echo $lon; ?>, <?php echo $lat; ?>), 5);
>
> // Create the marker and corresponding information window
>
>  function createInfoMarker(point, address) {
>    var marker = new GMarker(point);
>    GEvent.addListener(marker, "click", function()
> { marker.openInfoWindowHtml(address); });
>    return marker;
>
> }
>
> <?php mysql_select_db('josegoes');
> $qessx = mysql_query("SELECT DISTINCT * FROM ex_data WHERE city =
> '$city' GROUP BY street ORDER BY title LIMIT $set_limit, $limit");
> $thenumber = 1;
> while($row = mysql_fetch_array($qessx))
>   {
>
>  ?>
> var point = new GPoint(<?=$row['longitude'];?>, <?=$row['latitude'];?>);
>
> address = "<span class='googtitle'><? echo $thenumber; ?>. <?=
> $row['title'];?></span><br /><span 
> class='googphone'><?=$row['phone'];?></span><br /><span 
> class='googaddre'><?=$row['street'];?></span><br /
> ><span class='googaddre'><?=$row['city'];?>, <?=$row['state'];?> <?=
>
> $row['zipcode'];?></span>";
> var marker = createInfoMarker(point, address);
> map.addOverlay(marker);
>
> <?php $thenumber++; } ?>
>
> <?php mysql_select_db('edirectory_dfwdine');
> $region = $region_id;
> $listy = mysql_query("SELECT * FROM Listing WHERE region_id =
> '$region'");
> while($rowa = mysql_fetch_array($listy))
>   {
>
> ?>
> var point = new GPoint(<?=$rowa['longitude'];?>, <?=$rowa['latitude'];?>);
>
> address = "<span class='googtitle'><?=$rowa['title'];?></span><br /><span 
> class='googphone'><?=$rowa['phone'];?></span><br /><span
>
> class='googaddre'><?=$rowa['address'];?> <?=$rowa['address2'];?></
> span><br /><span class='googaddre'><?=$city;?>, <?=$state;?> <?=
> $rowa['zip_code'];?></span>";
> var marker = createInfoMarker(point, address);
> map.addOverlay(marker);
> <?php } ?>
>
>     //]]>
>     </script>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to