Help sorting products into columns

Hi AgentBristow,

Is a public url available that shows the page in progress? And do you have a mockup or example page that shows what you want it to look like?

The standard process I follow is to get my mockup looking the way I want (often that's the hardest part) and then view source on that and the CMS generated version and see what the difference is (and try and fix that).

Based on the posted code it looks like the first div needs to come after the td. Then the same div and td need to go after the second foreach. I'm not sure what the format is suppose to be though.

Are there multiple records on the page? Do you want one row of images for each record or just one long row of images wrapping at the 5th column?

Let me know and I'll try and help! :)

Thanks! After fiddling and moving those as suggested I got it to work. It's funny how simply moving something below something else can make such a huge difference!

I have encountered a similar problem on another page of the same website that I can seem to solve.

I don't want the URL to be public so have sent that through to you in a PM so you can review it if needed. The code is below for anyone who can help.

I am trying to get the products to display in in groups of 5 columns under their sections. All the data is displaying fine, however I can't get them into columns properly. The first section works fine, however the ones after don't. They are displaying the first line of products with 2 columns, and then 5 for everything after, the next with 3 in the first line and so on. Can't figure out what I did wrong.


<?php
require_once "/urlremovedbyme/viewer_functions.php";

list($advanta_brochuresRecords, $advanta_brochuresMetaData) = getRecords(array(
'tableName' => 'advanta_brochures',
));

list($sturdyRecords, $sturdyMetaData) = getRecords(array(
'tableName' => 'sturdy',
));

list($freibergRecords, $freibergMetaData) = getRecords(array(
'tableName' => 'freiberg',
));

?>


<table border="0" cellpadding="0" cellspacing="0">
<tr>
<strong>Advanta</strong><br /><br />
<?php foreach ($advanta_brochuresRecords as $record): ?>
<?php if ($record['type'] != "Seating") ?>

<td width="200" align="center" valign="top" style="padding-bottom: 16px;">

<?php echo $record['product_title'] ?><br />

<?php foreach ($record['brochure'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>" class="BrochureImg">
<?php foreach ($record['thumbnail'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" alt="" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" alt="" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" vspace="6" /><br/>
<?php else: ?>
</a><br/>
<?php endif ?>
<?php endforeach ?>
<?php endif ?>
<?php endforeach ?>

<?php foreach ($record['brochure'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>">View Brochure ></a><br/></td>

<?php endif ?>

<?php $maxCols=5; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>
<?php endforeach ?>
<?php endforeach; ?>


</tr>
</table>
<br/>


<table border="0" cellpadding="0" cellspacing="0">
<tr>

<strong>Sturdy</strong><br /><br />
<?php foreach ($sturdyRecords as $record): ?>
<?php if ($record['type'] != "Seating") ?>

<td width="200" align="center" valign="top" style="padding-bottom: 16px;">

<?php echo $record['title'] ?><br />

<?php foreach ($record['brochure'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>" class="BrochureImg">
<?php foreach ($record['thumbnail'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" alt="" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" alt="" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" vspace="6" /><br/>
<?php else: ?>
</a><br/>
<?php endif ?>
<?php endforeach ?>
<?php endif ?>
<?php endforeach ?>


<?php foreach ($record['brochure'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>">View Brochure ></a><br/></td>

<?php endif ?>

<?php $maxCols=5; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>
<?php endforeach ?>
<?php endforeach; ?>

</tr>
</table>


....ETC ETC ETC

Hi AgentBristow,

When using that little code snippet multiple times on the same page just use a different variable instead of $count or it will remember the count from the last section and be continuing with that.

Instead of this:

<?php $maxCols=5; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>

Use this:

<?php $maxCols=5; if (@++$count1 % $maxCols == 0): ?></tr><tr><?php endif; ?>

<?php $maxCols=5; if (@++$count2 % $maxCols == 0): ?></tr><tr><?php endif; ?>

<?php $maxCols=5; if (@++$count3 % $maxCols == 0): ?></tr><tr><?php endif; ?>

Hope that helps!