Contributions

Manufacturer displays incorrectly.

Category & Manufacturers name in Product_Info Page (complete working contribution)

Now both the category & manufacturer name both show up.

Thanks Dave Nesbitt for your help

Sorry the below version only works when model is in use but if not in use it doesn't so here is a fix so it now works on both

did a bit of correcting to get manufacturer name to show up here it is.

It works for me so hopefully it will work for you

I added a database call so that manufacturer would actually show up. There was no call to the manufacturer name in my version of product_info.php and I am running MS2.2

Support can be found here:
http://forums.oscommerce.com/index.php?showtopic=198958

Modification Description:
1. Maj (contribution originator) expressed help with SQL syntax and that is what I have provided.
2. Added support forum link.
3. Simplified install instructions.
4. Added check to see if manufacturer name exists and if not you will not get "Mfg" printed.
5. Released for MS2

Tip: if you are just looking to add category name only, please see contribution: 3412

Support: Either contact me directly or use the forums.
osCommerce ID: oscStudio
E-mail: support@oscStudio.com

This Contribution Adds Category Name & Manufacturers name of the product on the product info. page under the product name (where the model number appears). It addes these two fields right after the model number to that you have the 3 fileds under the product name:
"model number Category name Mfg:Manufacturers name"
I don't know how to use aliases for table name with an outer join in mysql. so the table names are hardcode (which is one line). If someone knows how to do this, it will meet the conventions.