Here is my DB with the custom fields I created. Also I named all 4 files that go in the admin folder, details.php
I have it working great with the drop ship that was provided from my supplier. All fields call into my products backend page, now I want to show the fields in the products page in a spry tab I have created.
Code:
ALTER TABLE products ADD products_Detailed_Description varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Plating_Color varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Style varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Stone_Colors varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Base_Metal varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Setting_Type varchar(32) NULL default NULL after products_model;
ALTER TABLE products ADD products_Clasp varchar(32) NULL default NULL after products_model;


INSERT INTO product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES 
(NULL, 'Show Product Detailed Description', 'SHOW_PRODUCT_INFO_Detailed_Description', '0', 'Show the detailed description on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product Plating Color', 'SHOW_PRODUCT_INFO_Plating_Color', '0', 'Show the plating color on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product style', 'SHOW_PRODUCT_INFO_Style', '0', 'Show the style on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product Stone Colors', 'SHOW_PRODUCT_INFO_Stone_Colors', '0', 'Show the stone colors on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product Base Metal', 'SHOW_PRODUCT_INFO_Base_Metal', '0', 'Show the base metal on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product Setting Type', 'SHOW_PRODUCT_INFO_Setting_Type', '0', 'Show the setting type on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
(NULL, 'Show Product Clasp', 'SHOW_PRODUCT_INFO_Clasp', '0', 'Show the clasp on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
This is the code I created to show on the products page. Doesn't seem to work though!
PHP Code:
<?php echo (($flag_show_product_info_detailed_description == and $products_detailed_description != '') ? '<li>' TEXT_PRODUCT_DETAILED_DESCRIPTION $products_chain '</li>' '') . "\n"?>
Also another code I used.
PHP Code:
<?php if ($products_detailed_description != '') { ?>
<div id="productDescription" class="productGeneral biggerText"><?php echo stripslashes($products_detailed_description); ?></div>
<br class="clearBoth" />
<?php ?>
Still confused...