i would like to display statistics information and show this on a map with multiple markers

i have initially created for a single marker the example is at
http://www.sudhakargolakaram.co.in/files/stats.php

for this i have written the following in the php file

PHP Code:

echo ('
<script type="text/javascript" src="jquery-1.3.2.min.js"></script>

<script src="maps api key"></script>
    
<script src="jquery.googlemaps1.01.js"></script>
');

$lat="-36.847385";
$lon="174.765735";

echo('
<script type="text/javascript"> 
    $(document).ready(function() { 
        $("#map_canvas").googleMaps({
            markers: {
                latitude:     '); echo $lat; echo(',
                longitude: '); echo $lon;
            echo(' }
        }); 
    }); 
</script> 
');
?> 


this is working fine

however i would like to get the values of the latitude and longitude values from mysql using select query and pass the values of latitude and longitude to the javascript code using a while loop

the code to display multiple markers is

<script type="text/javascript"> 
	$(document).ready(function() { 
		$('#map_canvas').googleMaps({
			markers: [{
				latitude: 	37.4416,
				longitude: -122.1516
			},{
				latitude: 	37.4516,
				longitude: -122.1616
			},{
				latitude: 	37.4566,
				longitude: -122.1666
			}]
		}); 
	}); 
</script>

this multiple markers is quite different to single marker as this does not have },{ for the last marker

in terms of the syntax of the php code how can i write the php code so that i will get the output in the browser as mentioned above for multiple markers

thanks

Try something like this:

PHP Code:

<script type="text/javascript">
    $(document).ready(function() {
        $('#map_canvas').googleMaps({
            markers: [<?php
$sql = "SELECT lat, long FROM geo_table";
if ($a_query = $db->query($sql)) {
  if ($a_query->num_rows> 0) {
    $a_row_prefix = '';
    while ($a_row = $a_query->fetch_object()) {
      echo $a_row_prefix.'
      {
                latitude : '.$a_row->lat.',
                longitude: '.$a_row->long.'
            }';
            $a_row_prefix = ',';
    }
  }
}
?>]
        });
    });
</script>

By having a prefix that starts out as an empty string and then is thereafter set as the separator, a comma, you can add commas only as needed.

Hope that helps.

thanks