// pull the manufacturers_id from the products table based on products_id
$manufac_id_query = tep_db_query("select manufacturers2_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
$manufac_id = tep_db_fetch_array($manufac_id_query);
$manufac_ids = $manufac_id['manufacturers2_id'];
// get the manufacturer's name from the manufacturers table based on the manufacturers_id from the query above
$manufac_title_query = tep_db_query("select manufacturers2_name from " . TABLE_MANUFACTURERS2 . " where manufacturers2_id = '" . $manufac_ids . "'");
$manufac_title = tep_db_fetch_array($manufac_title_query);
$manufacs_title = $manufac_title['manufacturers2_name'];
?>