Wasn't it mfdesigns who wrote:
>$query = "SELECT house_number, street, zip FROM property_table";
>
>$result = mysql_query($query);
>while($row = mysql_fetch_array($result, MYSQL_ASSOC))
>
>{
>
>$house_number = $row['house_number'];
>$street = $row['street'];
>$zip = $row['zip'];
>
>}
I don't know SQL, but shouldn't there be a WHERE clause in there
somewhere? As it stands, that code reads through the whole database,
updating the variables each time. When the while{} loop completes, the
variables contain the data from the last record.
Take a look at the code that generates the displayed details for the
property. It gets the correct address, number of beds and price for the
property. So it should be possible to do the same when retrieving the
address for the map.
--
http://econym.org.uk/gmap
The Blackpool Community Church Javascript Team
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
