multiple records

29 posts by 4 authors in: Forums > CMS Builder
Last Post: October 12, 2010   (RSS)

By (Deleted User) - August 24, 2010

Oops, my bad :)

Should be attached now.

Thanks Donna.

ps. CMS Builder working great so far - very impressed!
Attachments:

smesa.php 5K

Re: [smesa] multiple records

By Jason - August 24, 2010

Hi Shawn,

I've made some changes to the file. I removed all of the "next, previous" page stuff as the file will only ever display 5 records.

This code should work for images as long as the upload field in both news_finance and news_technology are both called "images". Give it a try and let me know if you run into any problems.

Thanks.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Attachments:

smesa2.php 4K

Re: [Jason] multiple records

By (Deleted User) - August 24, 2010

Excellent Jason, it's working well. Don't want to throw a spanner in the works but what if I wanted the next and previous to show the next 5 items - would that be possible?

This would be useful to maintain my layout to only showing 5 items but allowing users to browse older posts.

Re: [smesa] multiple records

By Jason - August 24, 2010

Hi,

The way this code is set up, there isn't an easy way of doing this. This is because the recordSet you're outputting is a combination of multiple queries. That being said, it is possible to do, but would require a greater degree of customization. If this is something you're interested in, we can take a look at doing this through our consulting service. Just send an email to consulting@interactivetools.com and we can get you a quote on what it would take.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] multiple records

By Chris - August 24, 2010

Hi there,

Yes, this would be very tricky the way that you've got it set up.

However, if you were to use one section with a "category" field (instead of multiple sections,) it would be easy to get pagination working. For more information on how to do this, check out the [url http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/Sub-categories_Tutorial_P77230/]Sub-categories Tutorial[/url].
All the best,
Chris

Re: [chris] multiple records

By (Deleted User) - August 24, 2010

Hi Chris,

Your way definately makes sense but how would you then display just one of the categories if you needed to?

i.e. if I created categories: technology, finance, marketing, etc. and only wanted finance articles to display - how would I do that?

Basically my overall goal is to have seperate pages each with their own articles and a homepage that displays the latest articles added to each section.

Re: [smesa] multiple records

By Jason - August 25, 2010

Hi,

If all of your articles appeared in only one section, with each having a different category, you could pull out one category like this:
example:
list($financeRecords,$financeMetaData)=getRecords(array(
'tableName' => 'articles',
'allowSearch' => false,
'where' => "category = 'finance'",
));

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [smesa] multiple records

By Jason - August 25, 2010

Hi,

Glad to hear that everything is going well for you. Let me know if you run into any issues.

Probably the best place to send a testimonial to would be sales@interactivetools.com

Thanks.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] multiple records

By (Deleted User) - August 25, 2010

Hi Jason,

How would you make this a drop down instead of a list?

<ul>
<li><a href="?">(All Articles)</a></li>
<?php foreach ($categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>

<?php if ($categoryRecord['_isSelected']): ?><b><?php endif ?>
<a href="?category=<?php echo $categoryRecord['num'] ?>"><?php echo $categoryRecord['name'] ?></a>
<?php if ($categoryRecord['_isSelected']): ?></b><?php endif ?>

<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>
</ul>