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.

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.

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)); ?>

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:

<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.

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

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

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?

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

See message

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:

<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:

<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>