I spoke too soon; i am now having the same problem. Not sure if it is the zoom setting, my DB structure or my recordset.
here is my page
store-locator.php
I have 2 recordsets from the same table. 1 supplies the map, the other populates a repeat region with the store listings.
the map recordset-
mysql_select_db($database_connsecret, $connsecret);
$query_rs_storelocation = "SELECT store_locator.store_name, store_locator.store_address, store_locator.store_city, store_locator.store_state, store_locator.store_zip, store_locator.store_phone, store_locator.store_active FROM store_locator WHERE store_locator.store_active = 'yes'";
$rs_storelocation = mysql_query($query_rs_storelocation, $connsecret) or die(mysql_error());
$row_rs_storelocation = mysql_fetch_assoc($rs_storelocation);
$totalRows_rs_storelocation = mysql_num_rows($rs_storelocation);
the repeat region store listings recordset-
mysql_select_db($database_connsecret, $connsecret);
$query_rs_stores = "SELECT store_locator.store_name, store_locator.store_link, store_locator.store_address, store_locator.store_city, store_locator.store_state, store_locator.store_zip, store_locator.store_phone, store_locator.store_active FROM store_locator WHERE store_locator.store_active = 'yes' ORDER BY store_locator.store_state, store_locator.store_city, store_locator.store_name";
$query_limit_rs_stores = sprintf("%s LIMIT %d, %d", $query_rs_stores, $startRow_rs_stores, $maxRows_rs_stores);
$rs_stores = mysql_query($query_limit_rs_stores, $connsecret) or die(mysql_error());
$row_rs_stores = mysql_fetch_assoc($rs_stores);
I am in the process of loading more store information into the db and i started having the problem today.
Page takes a long time to load and then the zoom jumps back and forth a few times and many of the locations are not shown on the map. Not consistant that i can see.
