Displaying all subcategories & adding a separator

[NJHomeGuide]

I need help to show all the subcategories (below the main category). I would also like each category to be separated by commas.

Currently, only 3 subcategories are displayed with no separator. Please go to
http://www.njhomeguide.com/pros to see what I'm talking about.

Any help with this would be greatly appreciated.

[Eric Barnes]

You would have to manually change this in the index.php file.

If you open it and locate this:

PHP Code:

while($arow=$result2->fetch())
        {
            $add_cats.='<a href="category.php?type='.$rs['id'].'&sec='.$arow['id'].'">'.$arow['name'].'</a> ';
        } 


Then change it to:

PHP Code:

while($arow=$result2->fetch())
        {
            $add_cats.='<a href="category.php?type='.$rs['id'].'&sec='.$arow['id'].'">'.$arow['name'].'</a>, ';
        } 


[NJHomeGuide]

Thank you for the comma separator.

How do I show all the subcategories (below the main category)? Only 3 are displaying now and I want all of them to display.

[Eric Barnes]

Just above that change is a sql query:

PHP Code:

$sSQL2 = "SELECT id,name,image FROM ".PREFIX."categories WHERE parent_id = ".$rs['id']." AND display<>'N' ORDER BY cOrder LIMIT 3"; 


Change it to:

PHP Code:

$sSQL2 = "SELECT id,name,image FROM ".PREFIX."categories WHERE parent_id = ".$rs['id']." AND display<>'N' ORDER BY cOrder"; 


[NJHomeGuide]

Thanks Eric.

Now I have another problem. I am trying to make formatting changes to the main categories on the index page. When I FTP the file categories/maincategories.tpl.php - the changes don't show up. I don't understand, it worked yesterday.

I have already cleared the compiled templates and the templates_c folder is empty.

[Eric Barnes]

That is strange.

Here are a few things you could try:
1. Physically open the file off the server and see if it does include your changes.
2. Make sure you are not getting any ftp errors like "over disk space" etc.
3. Try to add something like <h1>TEST</h1> and see if that shows.
4. Make sure you are uploading it to the correct template folder.

[NJHomeGuide]

I know, it's driving me crazy. It's definently going in the right folder. The changed file (maincategories.tpl.php) is on the server, but it seems the classifieds software is not using it.

Is there a setting somewhere in the program causing this?

[Eric Barnes]

Can you give me a link?

[NJHomeGuide]

Eric,
I'm still on the same page: http://www.njhomeguide.com/pros/index.php

I just replaced maincategories.tpl.php with the original file and nothing happened. I checked the server and the new file is there, but when I reload the page and check the source - it's not there.

[NJHomeGuide]

Here's more info: when I make changes to:

subcategories.tpl.php - the changes show up
maincategories.tpl.php - the changes DON'T show up

It's odd that the system would process one file but not the other?