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

Repeating Tables

Thread began 6/04/2013 6:35 pm by Paul | Last modified 6/13/2013 9:17 am by Jason Byrnes | 765 views | 18 replies |

Paul

Repeating Tables

I followed the Tutorial: Repeating Tables server behavior. I want the results of my repeating table to show in 5 columns across the page.

The page creates it basically correct (the links work), but the page isn't looking correct (see the image).

Any advice would be appreciate.

Attached Files
categories.php
Sign in to reply to this post

Jason ByrnesWebAssist

you added the repeating table, then added the content and a repeat region to the cell.

you don't need to add the additional repeat region.

just add the repeating table, then add the content to the cel that is created, it will handle the repeating on its own.

Sign in to reply to this post

Paul

Jason,

Here is what I did now...

I went through the WA Repeat Region Wizard.
Selected ALL records
5 Columns
Chose my CSS for the odd and even rows
Clicked ok

Went into the rsProducts Recordset
Added the prodCategories database item and SELECT it to the SQL statement (as the tutorial said to do).

Changed out the [Your Repeated Content] with the prodCategories field.
At this point, the page looks good, except there are no links to the products in each category...

The problem is that I am trying to use the code you gave me the other day (see below) to click on a category and have the results page show all the product for that category. This is where the page gets funky looking. The tutorial said to go to the ADVANCED button in the recordset and select prodCategories. This act removes the other fields from the recordset so I can't do what you did below.

What do I do?

<a href="categories_products.php?<?php echo $row_rsProducts['prodID']; ?>=<?php echo $row_rsProducts['prodName']; ?>">
<?php do { ?>
<p><a href="categories_products.php?prodCategories=<?php echo $row_rsProducts['prodCategories']; ?>&Search=Search"><?php echo $row_rsProducts['prodCategories']; ?></p>
<?php } while ($row_rsProducts = mysql_fetch_assoc($rsProducts)); ?>

Sign in to reply to this post

Jason ByrnesWebAssist

which tutorial are you referring to that is having you use the advanced recordset?

you should not need to make any changes to the recordset, you just need to use the following code for the links:

php:
<a href="categories_products.php?prodCategories=<?php echo $row_rsProducts['prodCategories']; ?>&Search=Search"><?php echo $row_rsProducts['prodCategories']; ?></p>



in the code you have above, you have a do loop around the link, that is the problem.

Sign in to reply to this post

Paul

Hey Jason,

That worked fine as far as showing the categories in 5 columns, but I have 6 categories and the 6th one isn't showing, I assume, on row 2, column 1.

The tutorial I referred to is Webassists: Repeating Tables server behavior: http://www.webassist.com/community/tutorials/view_tutorial.php?tid=24

Sign in to reply to this post

Jason ByrnesWebAssist

In the repeating table wizard, make sure to select all records for rows.

I dont see anywhere in that tutorial that has you editing a recordset

Sign in to reply to this post

Paul

Jason,

I know I'm doing it correctly. I clicked in my empty DIV (did not insert anything at this point), went to the wizard, chose All Records in the rows and 5 columns. There are 6 categories, but only the first 5 are showing. The second row does not show. I even created a new page because it looked like every time I re-ran the wizard it added more code. I've enclosed the new file.

As for the Tutorial, under the Create a Recordset section, from item 9 - 11, it shows to select the field you want (in the tutorials case it is the "items" field, but in mine it is "prodCategories" and says to select it and click the SELECT button.

Is that not correct?

Attached Files
categories2.php
Sign in to reply to this post

Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

Sign in to reply to this post

Paul

See message

Sign in to reply to this post

Jason ByrnesWebAssist

What version of Data Briodge do you have installed?

make sure to isntall the latest version, 1.1.3, if you have a [revious version installed, make sure to unisntall it from the extension manager.

the problem is that the loop around the TR tag is missing. the table code:


php:
<table width="350" id="repeated_table_1">


        <tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>" >
          <?php
    
// RepeatSelectionCounter_1370446954168 Begin Loop
    
$RepeatSelectionCounter_1370446954168_IterationsRemaining $RepeatSelectionCounter_1370446954168_Iterations;
    while(
$RepeatSelectionCounter_1370446954168_IterationsRemaining--){
        if(
$RepeatSelectionCounterBasedLooping_1370446954168 || $row_rsProducts){
?>
            <td><a href="categories_products.php?prodCategories=<?php echo $row_rsProducts['prodCategories']; ?>&Search=Search"><?php echo $row_rsProducts['prodCategories']; ?></p></td>
            <?php
    
// RepeatSelectionCounter_1370446954168 Begin Alternate Content
    
else{
?>
              <td>&nbsp;</td>
              <?php // RepeatSelectionCounter_1370446954168 End Alternate Content
        
if(!$RepeatSelectionCounterBasedLooping_1370446954168 && $RepeatSelectionCounter_1370446954168_IterationsRemaining != 0){
            if(!
$row_rsProducts && $RepeatSelectionCounter_1370446954168_Iterations == -1){$RepeatSelectionCounter_1370446954168_IterationsRemaining 0;}
            
$row_rsProducts mysql_fetch_assoc($rsProducts);
        }
        
$RepeatSelectionCounter_1370446954168++;
    } 
// RepeatSelectionCounter_1370446954168 End Loop
?>
        </tr>
      </table>





should be:

php:
<table width="350" id="repeated_table_1">

        <?php do { ?>
        <tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>" >
          <?php
    
// RepeatSelectionCounter_1370446954168 Begin Loop
    
$RepeatSelectionCounter_1370446954168_IterationsRemaining $RepeatSelectionCounter_1370446954168_Iterations;
    while(
$RepeatSelectionCounter_1370446954168_IterationsRemaining--){
        if(
$RepeatSelectionCounterBasedLooping_1370446954168 || $row_rsProducts){
?>
            <td><a href="categories_products.php?prodCategories=<?php echo $row_rsProducts['prodCategories']; ?>&Search=Search"><?php echo $row_rsProducts['prodCategories']; ?></p></td>
            <?php
    
// RepeatSelectionCounter_1370446954168 Begin Alternate Content
    
else{
?>
              <td>&nbsp;</td>
              <?php // RepeatSelectionCounter_1370446954168 End Alternate Content
        
if(!$RepeatSelectionCounterBasedLooping_1370446954168 && $RepeatSelectionCounter_1370446954168_IterationsRemaining != 0){
            if(!
$row_rsProducts && $RepeatSelectionCounter_1370446954168_Iterations == -1){$RepeatSelectionCounter_1370446954168_IterationsRemaining 0;}
            
$row_rsProducts mysql_fetch_assoc($rsProducts);
        }
        
$RepeatSelectionCounter_1370446954168++;
    } 
// RepeatSelectionCounter_1370446954168 End Loop
?>
        </tr>
          <?php } while ($row_rsProducts mysql_fetch_assoc($rsProducts)); ?>
      </table>
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...