Smarty

[rts5678]

Hi, I am using the GoogleMapAPI to display maps/directions on an automotive website. However, I am having problems putting data dynamically in the

$map->addMarkerByAddress(populate address dynamically here);

Is there a way I can populate this address dynamically?

Are there any other ways to display map or populate address using pre-existing variables like $address, $state, $zipcode already in my code?

Any help will be appreciated.

Thanks,

[giggler]

You first have to connect to DB like usual and set SELECT and all that stuff, then where you have the $map...well this is what I have and it worked for me:

while ($currentrecord < $howmanyrecords)
{
$TITLE = mysql_result($result,$currentrecord,"TITLE");
$IMAGE = mysql_result($result,$currentrecord,"IMAGE");
$OWNER_ADDRESS = mysql_result($result,$currentrecord,"OWNER_ADDRESS");
$OWNER_CITY = mysql_result($result,$currentrecord,"OWNER_CITY");
$OWNER_STATE = mysql_result($result,$currentrecord,"OWNER_STATE");
$OWNER_ZIPCODE = mysql_result($result,$currentrecord,"OWNER_ZIPCODE");
$OWNER_TELEPHONE = mysql_result($result,$currentrecord,"OWNER_TELEPHONE");
$URL = mysql_result($result,$currentrecord,"URL");
// create some map markers
$map->addMarkerByAddress("$OWNER_ADDRESS $OWNER_CITY $OWNER_STATE $OWNER_ZIPCODE","$TITLE","<b>$TITLE</b>");
$currentrecord++;
}
_________________
http://www.tagacloud.com/?id=3072
http://www.linkwebdirectory.com