Category names Categories table

[tubetronics]

I posted this before, but I want to post agin, with the question simplified.

 

As you probably know, the categories have 2 tables - categories, and category descriptions. Everything about the category is listed in the categories table, except the category name - that is in the description table. I've added a name field the the category table, now how do I get the PHP side to look there for the name instead of the description table?

[spooks]

in the sql look for the table suffix, that ties with the field name prefix, so change cd to c

[tubetronics]

in the sql look for the table suffix, that ties with the field name prefix, so change cd to c

 

 

It worked for the list of categories in the category box on the left, but I can't find where to change this on the page. That is, when you select a category, it shows, on the page, all of the sub categories, and they are buttons to go to that sub category. Where do I change these at?

[tubetronics]

Nevermind - found it. I had overlooked a couple cd's in there.

[tubetronics]

It seems we are half way there. Changing the cd's to c's did make it display properly, but the problem is if I ditch the related record in the categories_description table, the category disappears from the list. In all of the PHP's that I've found that have that table, I've tried to get rid of it. In a couple cases all was good, and the web page looks fine, but on other lines when I try to get rid of it the same way, I get a syntex error.

 

I really need to ditch that descriptions table all together. I'm using Filemaker Pro to interface with this as I use that to run my business, but having this on two tables is really creating headaches.