Super Suite
Get all extensions for one suite price
Design Extender
Design and create unlimited websites
Data Bridge
Develop database-driven websites
eCart
Build a responsive shopping cart + checkout
MySQLi Server Behaviors
Generate streamlined MySQLi
Free PayPal Toolkit
Paypal, PayPal Credit, and Skype
Help
3/19/2010 5:57 am | #1 ddidion3394878 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
3/19/2010 12:10 pm | #2 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.
3/19/2010 8:10 pm | #3 ddidion3394878 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"> </td>
<td width="14"> </td>
<td colspan="2" class="style2"><div align="center">Find Local Gyms</div></td>
<td width="185"> </td>
</tr>
<tr>
<td height="28"> </td>
<td> </td>
<td colspan="2"> <div id="wagmp_map_33" style="width: 530px; height: 250px;"></div></td>
<td> </td>
</tr>
<tr>
<td height="51"> </td>
<td> </td>
<td colspan="2"><img src="images/box_backagt.jpg" width="543" height="31"></td>
<td> </td>
</tr>
<tr>
<td height="65" rowspan="2"> </td>
<td rowspan="2"> </td>
<td width="535">
<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"> </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"> </td>
<td height="101"> </td>
</tr>
<tr>
<td height="17" colspan="2"> </td>
<td height="17"> </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"> </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"> </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> </h2></th>
<th scope="col">© AmericanGymTrader.com 2010</th>
<th width="175" scope="col"><h2> </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>
3/22/2010 5:20 pm | #4 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.
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.
3/23/2010 6:21 am | #5 ddidion3394878 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.
3/23/2010 6:28 am | #6 ddidion3394878 Look at the link again. I made it easier for you to see.
find_gyms.php
3/23/2010 7:37 am | #7 ddidion3394878 3/23/2010 2:44 pm | #8 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.
3/23/2010 8:51 pm | #9 ddidion3394878 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.
3/23/2010 11:08 pm | #10 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.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.
©1999-2024 WebAssist.com Corporation. All rights reserved and all that jazz.
Account or customer service questions?
Please user our contact form.
Need technical support?
Please visit support to ask a question
Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...
Uploading file...