close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Map is adding a repeat region

Thread began 3/19/2010 8:57 am by ddidion3394878 | Last modified 7/16/2010 12:32 pm by Eric Mittman | 1890 views | 14 replies |

ddidion3394878

Map is adding a repeat region

When I install Pro maps to a page with a recordset that has a repeat region. It always adds a repeat region to the top of my table. The repeat region has no data. Just empty space. Delete the map and the repeated region goes away. When I set up my maps I select show multiple without default destinations

Sign in to reply to this post

Eric Mittman

Could you post back with a copy of the page that has the extra repeat region applied to it so that we have a reference for it? I'm not familiar with this issue and would like to see an example of the problem. Along with this please also include any additional info that you can think of about how the map was created.

Sign in to reply to this post

ddidion3394878

Re: Map adding repeat region

When I install the map I select
Address
Show Multiple
Do not check default destionation
Use star as a marker
size 520 X 250
do not add driving directions
page is at find_gyms.php




<?php require_once('Connections/database.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$maxRows_gyms = 10;
$pageNum_gyms = 0;
if (isset($_GET['pageNum_gyms'])) {
$pageNum_gyms = $_GET['pageNum_gyms'];
}
$startRow_gyms = $pageNum_gyms * $maxRows_gyms;

mysql_select_db($database_database, $database);
$query_gyms = "SELECT gyms.Gym, gyms.Address, gyms.City, gyms.`State`, gyms.Zip, gyms.link FROM gyms";
$query_limit_gyms = sprintf("%s LIMIT %d, %d", $query_gyms, $startRow_gyms, $maxRows_gyms);
$gyms = mysql_query($query_limit_gyms, $database) or die(mysql_error());
$row_gyms = mysql_fetch_assoc($gyms);

if (isset($_GET['totalRows_gyms'])) {
$totalRows_gyms = $_GET['totalRows_gyms'];
} else {
$all_gyms = mysql_query($query_gyms);
$totalRows_gyms = mysql_num_rows($all_gyms);
}
$totalPages_gyms = ceil($totalRows_gyms/$maxRows_gyms)-1;
?><!-- saved from url=(0014)about:internet -->
<HTML xmlns:v="urn:schemas-microsoft-com:vml">
<HEAD>

<link rel ="shortcut icon" type= "image/x-icon" href="images/favicon.ico">
<TITLE>Find Local Gyms</TITLE>
<meta name="description" content="Find Local Gyms, Health Clubs and Fitness Centers

">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1251" />
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<script type="text/javascript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>

<script type="text/javascript">
/*wagmp*/
<?php include("google_javascript/wagmp_map_33.php"); ?>
</script>
<script type="text/javascript" src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAf5tVBCDbQL__mugZWAL5HhQP2iSJyH5jQyqLc3obCB2FvXKMvhQw4zWIueO68ZCC_VvUEfHDtkeppA">/*wagmp*/</script>
</HEAD>
<body bgcolor="#FFFFFF" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="840" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="840
" height="191"><table width="840" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="141"><a href="index.php"><img src="images/Logo Star.jpg" alt="Home" name="Home" width="140" height="105"border="0" id="Home"></a></td>
<td width="491"><div align="center"><span class="style1">AMERICAN GYM TRADER</span></div>
<div align="center" class="style99">
<h2 align="center" class="style90"><span class="style2">Buy a Gym Membership - Sell a Gym Membership</span></h2>
</div></td>
<td width="208"><a href="users_LogIn.php"><img src="images/Log In Here.gif" alt="Login" name="Login" width="183" height="115" border="0" align="right" id="Login" /></a></td>
</tr>
</table>
<table width="750" border="0" cellspacing="5" cellpadding="5">
<tr bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<td height="32"><div align="center"><a href="index.php">Home </a> </div>
<div align="center" class="style39"> </div></td>
<td><div align="center" class="style39">
<p class="style137 style141"><a href="find_gyms.php" target="_self"></a><a href="buyamembership.php" target="_self" class="style33 style140">Buy a Gym Membership</a></p>
</div></td>
<td><div align="center" class="style39">
<div align="center">
<div align="center" class="style39">
<p><a href="sellamembership.php" target="_self">Sell a Gym Membership</a><a href="find_gyms.php" target="_self"></a></p>
</div>
</div>
</div></td>
<td><div align="center" class="style39">
<div align="center"><a href="find_gyms.php" target="_self">Find Local Gyms</a><a href="ad_delete.php" target="_self"></a></div>
</div></td>
<td><div align="center"><a href="FAQs.php">FAQs</a></div></td>
</tr>
</table>
<img src="images/header2.jpg" width="770" height="34" /></td>
</tr>
<tr>
<td height="122" background="images/back_line.gif"><table width="840" height="192" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="1217" height="192" valign="top"><table width="840" border="0" cellpadding="0" cellspacing="0" background="images/back_line.gif">
<tr>
<td width="93" height="28">&nbsp;</td>
<td width="14">&nbsp;</td>
<td colspan="2" class="style2"><div align="center">Find Local Gyms</div></td>
<td width="185">&nbsp;</td>
</tr>
<tr>
<td height="28">&nbsp;</td>
<td>&nbsp;</td>
<td colspan="2">&nbsp;<div id="wagmp_map_33" style="width: 530px; height: 250px;"></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="51">&nbsp;</td>
<td>&nbsp;</td>
<td colspan="2"><img src="images/box_backagt.jpg" width="543" height="31"></td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="65" rowspan="2">&nbsp;</td>
<td rowspan="2">&nbsp;</td>
<td width="535">&nbsp;
<table width="467" cellpadding="5">

<?php do { ?>
<tr>
<td width="88" rowspan="3"><div align="center"><img name="" src="" width="75" height="75" alt=""></div> <div align="center"></div></td>
<td><div align="center" class="style2"><a href="<?php echo $row_gyms['link']; ?>"><?php echo $row_gyms['Gym']; ?></a></div></td>
</tr>
<tr>
<td><div align="center" class="px12"><strong><?php echo $row_gyms['Address']; ?></strong></div></td>
</tr>
<tr>
<td height="24"><div align="center"><span class="px12"><strong><?php echo $row_gyms['City']; ?>,<?php echo $row_gyms['State']; ?>,</strong></span><strong class="px12"><?php echo $row_gyms['Zip']; ?></strong></div></td>
</tr>

<tr>
<td width="88">&nbsp;</td>
<td width="351" height="37"><div align="center"></div></td>
</tr>

<?php } while ($row_gyms = mysql_fetch_assoc($gyms)); ?>
</table></td>
<td width="13">&nbsp;</td>
<td height="101">&nbsp;</td>
</tr>
<tr>
<td height="17" colspan="2">&nbsp;</td>
<td height="17">&nbsp;</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/footer.gif" width="770" height="34" />
<table width="840" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="61" height="24" scope="col">&nbsp;</th>
<th width="209" scope="col"><span class="px12"><a href="termsandconditions.php">Terms and Conditions</a></span></th>
<th width="156" scope="col"><span class="px12"><a href="privacypolicy.php">Privacy Policy</a></span></th>
<th width="127" scope="col"><span class="px12"><a href="advertise.php">Advertise</a></span></th>
<th width="133" scope="col"><span class="px12"><a href="contact.php">Contact Us </a></span></th>
<th width="154" scope="col">&nbsp;</th>
</tr>
</table></td>
</tr>
<tr>
<td height="27"><table width="840" border="0" cellspacing="0" cellpadding="5">
<tr>
<th width="90" scope="col"><h2>&nbsp;</h2></th>
<th scope="col">&copy; AmericanGymTrader.com 2010</th>
<th width="175" scope="col"><h2>&nbsp;</h2></th>
</tr>
</table></td>
</tr>



</table>
<script src="ad_post.php" type="text/javascript">
</script>
<br>
<script type="text/javascript">
_uacct="UA-6780472-2";
urchinTracker();
</script>
</HTML>
<?php
mysql_free_result($gyms);
?>



<script type="text/javascript" src="google_javascript/wagmp_maps.js">/*wagmp*/</script>

Sign in to reply to this post

Eric Mittman

I'm not seeing the extra repeat region in this page. When I check on the code that you sent I can only see a single 'do while' pair.

php:
145: <?php do { ?>

162: <?php } while ($row_gyms mysql_fetch_assoc($gyms)); ?>



Where on the page is the extra repeat region? On the page that you linked to what is not looking correct there? I'm just not sure what the issue is after looking it over.

Sign in to reply to this post

ddidion3394878

Re: Map adding repeat region

There are only two records on the link that I sent you. However it shows three rows or placeholders.2 with data and the one on top without data. Look closely you will see an extra image holder and two comma's above the two records. I don't know if the recordset code has anything to do with this. Like I said it only happens when I install a map. Delete the map and all is ok.

Sign in to reply to this post

ddidion3394878

Look at the link again. I made it easier for you to see.
find_gyms.php

Sign in to reply to this post

ddidion3394878

Map Code

Could the problem be in the map code?

Sign in to reply to this post

Eric Mittman

I can definitely see the new entry that you have on the page, did you add this in statically? Please post back with the current copy of this page in a zip archive so I can take a look at the code on it.

For now you can just remove this extra row if you do not need it to be there.

Sign in to reply to this post

ddidion3394878

zip file

Eric, you do understand that if I could remove the extra row I would not have started this thread in the first place. The extra row is the whole problem.

I did add your name staticaly.

Attached Files
Webassist.zip
Sign in to reply to this post

neilo

Have you checked the records in your database? It looks as if you may have a record with no data in it.

It would be worth browsing the table and checking the records, and if there is an empty one you could just delete the record. If this is the case then you might want to add 'required' validation to the inset records form fields, or not null to the db table columns.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...