Understood and I have read it, however, I am green to all of this. The php works on its own, the js works on its own, but they don't work together and it is baffling to me.
- just the js with a simple for next to make a few points http://www.sixmanfootball.com/test_map_one.php - just the php http://www.sixmanfootball.com/test_map_two.php all of it http://www.sixmanfootball.com/test_map.php I know I am an idiot and doing something wrong On Oct 21, 1:49 am, "Barry Hunter" <[EMAIL PROTECTED]> wrote: > You shoudl read > this:http://groups.google.com/group/Google-Maps-API/web/suggested-posting-... > > as the API is basically client side, most of the debugging can be done > with a link - its then your job to get the php creating the right > javascript :) > > > > On Tue, Oct 21, 2008 at 4:06 AM, sixmanguru <[EMAIL PROTECTED]> wrote: > > > I am new to this and have been trying to solve this one problem in my > > spare time. > > > 1. I can get the map portion to work with a single piece of info or > > loop completely in javascript and a fixed starting point. > > > 2. I can have the several nested queries that produce statements with > > data that looks correct (when I echo them) > > > 3. but for the life of me, I cannot get it all to work together, using > > my queried data to make a map. > > > I apologize in advance if this has been hashed out elsewhere > > > <script src="http://maps.google.com/maps?file=api&v=2&key=mykey"; > > type="text/javascript"></script> > > > <div id="map" style="width: 800px; height: 600px"></div> > > > <script type="text/javascript"> > > //<![CDATA[ > > > var map = new GMap2(document.getElementById("map")); > > map.addControl(new GLargeMapControl()); > > map.addControl(new GMapTypeControl()); > > map.addControl(new GScaleControl()); > > map.setCenter(new GLatLng(32.2, -99.1), 7, G_NORMAL_MAP); > > > // Creates a marker whose info window displays the given number > > function createMarker(point, number) > > { > > var marker = new GMarker(point); > > // 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; > > }; > > > <?php > > include('connectionfile.inc'); > > > /// put it all here > > $dblink = mysql_connect('localhost', $dbuser, $dbpass); > > $dblinked = mysql_select_db('mydatabase', $dblink); > > > $q12 = "SELECT * FROM week_info WHERE current_week=1"; > > $r12 = mysql_query($q12); > > > while($a12 = mysql_fetch_array($r12)) > > { > > $key = $a12[week]; > > $words_caps=$a12[weekwordscaps]; > > $dates=$a12[dates]; > > } > > > $q2 = "SELECT team_a, team_b, game_location FROM schedule_games WHERE > > game_week=$key ORDER BY game_location ASC"; > > $r2 = mysql_query($q2); > > > echo "<font face='Arial, Helvetica, sans-serif'><strong><font > > size='3'>2008 WEEK ".$words_caps." MAPS OF GAMES<br>".$dates."</ > > strong></font><p>"; > > > while($a2 = mysql_fetch_array($r2)) > > > { > > $team_a = $a2[team_a]; > > $team_b = $a2[team_b]; > > $game_site = $a2[game_location]; > > $site_search = mysql_real_escape_string($game_site); > > > $q3 = "SELECT * FROM sixman_teams WHERE > > team_name='$site_search' > > and team_lat<>0"; > > $r3 = mysql_query($q3); > > while($a3 = mysql_fetch_array($r3)) > > > { > > $game_lat = $a3[team_lat]; > > $game_long = $a3[team_long]; > > $game_name = $site_search; > > echo "var point = new GLatLng(" . $game_lat > > . "," . $game_long . > > ");\n"; > > echo "var marker = createMarker(point, '" . > > addslashes($game_name) . "');\n"; > > echo "map.addOverlay(marker);\n"; > > echo "\n"; > > } > > > mysql_close($link); > > ?> > > > //]]> > > </script> > > -- > Barry > > -www.nearby.org.uk-www.geograph.org.uk- --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
