products_to_cateories

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227927#227927
----------------------------------------------------------------

Hi,

I'm trying to customise a version of osCommerce.

problem is that I'm trying to get it so that I can take a products file from an external source and put it into the products table automatically - no problems here.

where the problem arises is when I try and set up the system with an extra field in the products table called 'products_category'. I'm wonderig where i go to alter the MySQL query so i can retrieve from the products table without having to reference the 'products_to_cateories' table.

any help appreciated.

thanks guys

Enda
--