Hi Jack,
Can you give me a helping hand in changing the query for the manufacturers page so that I can have a different title to the manufacturer name that is displayed on the page.
Basically I want to have the name of the manufacturer on the page but have a different title.
This is how I have got to getting close to having what I want:
$db_query = tep_db_query("select m.manufacturers_name as categories_name, mi.manufacturers_htc_description as categories_htc_description from " . TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " mi where mi.languages_id = '" . (int)$languages_id . "' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
This amended code means I have got the title and manufacturer name displaying how I want but this makes the description not display.
Hope you can help.
Thanks
James