Category description in different table

[tubetronics]

I use Filemaker Pro for my business, and I have it linked to the MySQL tables for my store. I'm still setting things up, but aside from a few minor issues to work out, things are going great. However, it would be easier for me if I could combine a couple tables in OSCommerce. The first being the categories and categories_name tables. I'm kind of curious as to why there are two tables for this, when the category name could just as easily be put in the categories table, although I'm guessing it is for if you have different languages. Anyway, I've added a name field in the categories table via my PHPadmin on my web control panel, but now I need to figure out how to change OSCommerce to use that field, instead of the related table. I know that it should be a fairly simple code change in the locations that it needs to be change, but I know that there may be quite a few places to change it.

[web-project]

Category description in different table

possible, simply create new table and use JOIN sql update the sql queries.

[tubetronics]

possible, simply create new table and use JOIN sql update the sql queries.

 

But that's kind of the problem now - I already have two tables (by default) I only want one categories table that includes the category name. right now, out of the box there are two tables. One has the basic category info, the other is only the name and language ID.