Category Menu duplicate names problem

10 posts by 2 authors in: Forums > CMS Builder
Last Post: April 14, 2010   (RSS)

By videopixel - April 13, 2010

Hello,

I have setup my category menu: (example)

Biography
- Personal
- Digital Photography
- Website Design

Links
- Friends
- Digital Photography
- Website Design

The problem is when i choose in the section 'Biography' the category from a pull down menu (breadcrumb format) 'Website Design' or 'Digital Photography' the program takes the category from 'Links'- 'Website Design' or 'Digital Photography' ???

Re: [videopixel] Category Menu duplicate names problem

By Jason - April 13, 2010

Hi,

Are you having this problem inside CMS Builder or on your page?

If you post the address to the page I'll take a look.

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] Category Menu duplicate names problem

By videopixel - April 13, 2010

It's in the backend...

Re: [videopixel] Category Menu duplicate names problem

By Jason - April 13, 2010

Okay, if you could email me your CMS details (address/username/password) to jason@interactivetools.com, I'll take a look.

Please don't post login details on the forum.

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] Category Menu duplicate names problem

By videopixel - April 14, 2010

Perfect everything works now... except one thingy: in the front-end it displays the num now (that's normal) but i want the name... maybe thats why i stumbled into this whole problem i think :-)

Re: [videopixel] Category Menu duplicate names problem

By Jason - April 14, 2010

Okay, no problem.

Can you post the address where you are having the problem as well as the php file?

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] Category Menu duplicate names problem

By videopixel - April 14, 2010

Maybe this can help:

list($blogRecords, $blogMetaData) = getRecords(array(
'tableName' => 'blog',
'perPage' => '6',
));




and then:


<?php foreach ($blogRecords as $record): ?>
<div>
<div id="blog_title"><?php echo $record['title'] ?></div>
<div id="blog_category"><?php echo $record['category'] ?></div>
<div id="blog_excerpt"><?php echo $record['excerpt'] ?></div>
</div>
<?php endforeach ?>


problem is the <?php echo $record['category'] ?> outputs a number instead of the name...



thanks

Re: [videopixel] Category Menu duplicate names problem

By Jason - April 14, 2010

I think we have a pretty easy fix here.

First thing we're going to do is set up an array of all of the categories in the database. Put this code somewhere near the top of your file:

<?php
list($categoryRecords,$categoryMetaData) = getRecords(array(
'tableName' => 'categories',
));

$numToName=array();

foreach($categoryRecords as $record){
$numToName[$record['num']]=$record['name'];
}
?>
Next, where you want to output the name of the category, use the following:

echo $numToName[$record['category']]

This should output the category name instead of the number. Give that a try and let me know if it works.
---------------------------------------------------
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] Category Menu duplicate names problem

By videopixel - April 14, 2010

Everything works as expected!

thanks Jason