Solved

Duplicate results using Dreamweaver Repeat Region

Posted on 2009-04-08
8
547 Views
Last Modified: 2013-12-13
I am using Dreamweaver to create a dynamic application.  I have entered some sample data into my database and verified that it is only entered once.  I have used Dreamweaver to setup a Repeat Region.  When i test the application, it returns duplicate results, (i.e. record 1, record 2, <BR>record 1, record 2).

I have checked over the code and don't see anything that should be causing this problem.  Any Advice?
0
Comment
Question by:axessJosh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24099509
Hi axessJosh,

>> I have checked over the code and don't see anything that should be causing this problem.  Any Advice?

Yes. Let us check your code.
0
 
LVL 2

Author Comment

by:axessJosh
ID: 24099516
actually, after further review, the results are showing:

name 1 - result 1
name 1 - result 2
name 2 - result 1(repeat)
name 1 - result 2(repeat)

name is pulled from a separate table than the results.
0
 
LVL 2

Author Comment

by:axessJosh
ID: 24099546
Here is my DB setup.

users table - ID, name, PW
payees table - ID, name, address, city, state, Zip, acct
bills table - ID, users.ID(foreign), payees.ID(foreign), date submitted, amount, expense line


$colname_rsUsers = "-1";
if (isset($_GET['ID'])) {
  $colname_rsUsers = $_GET['ID'];
}
mysql_select_db($database_conClient, $conClient);
$query_rsUsers = sprintf("SELECT ID, name FROM users WHERE ID = %s", GetSQLValueString($colname_rsUsers, "int"));
$rsUsers = mysql_query($query_rsUsers, $conClient) or die(mysql_error());
$row_rsUsers = mysql_fetch_assoc($rsUsers);
$totalRows_rsUsers = mysql_num_rows($rsUsers);
 
$colname_rsBills = "-1";
if (isset($_GET['ID'])) {
  $colname_rsBills = $_GET['ID'];
}
mysql_select_db($database_conClient, $conClient);
$query_rsBills = sprintf("SELECT UsersID, payeesID, `Date`, Amount, payees.name FROM bills, payees WHERE UsersID = %s", GetSQLValueString($colname_rsBills, "int"));
$rsBills = mysql_query($query_rsBills, $conClient) or die(mysql_error());
$row_rsBills = mysql_fetch_assoc($rsBills);
$totalRows_rsBills = mysql_num_rows($rsBills);
?>
 
//normal head data //
 
<div id="bills">
  <h2>Your Existing Bills</h2>
   <?php do { ?>
     <?php echo $row_rsBills['name']; ?> - $<?php echo $row_rsBills['Amount']; ?> - <?php echo $row_rsBills['Date']; ?><br />
     <?php } while ($row_rsBills = mysql_fetch_assoc($rsBills)); ?>
 
    <a href="addBill.php">Add New Bill</a>
</div>

Open in new window

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 125 total points
ID: 24099548
Okay, then that behavior is "normal"

If you are pulling from two tables at once with a one-to-many relationship, the master row will repeat so long at the child rows match.

What you need to do is create a nested repeating region that limits the iteration of the master row while the child repeats.  Tom Muck has written an extension for you:

http://www.tom-muck.com/extensions/help/simulatednestedregion/
0
 
LVL 2

Author Comment

by:axessJosh
ID: 24099625
I downloaded the extension, restarted Dreamweaver.  How do i apply the extension once i have highlighted the text?
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24099656
Go back to the page linked above.  Instructions are there.
0
 
LVL 2

Author Comment

by:axessJosh
ID: 24099660
Oops, figured it out.

that worked for the name field, however, now it displays

name1 - record 1
- record 2
name 2 - record 1
- record 2
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24099891
You'll have to play around with how you are returning the data to get it to work the way you want.
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question