Multiple Descriptions

[doodlebee]

Right - I agree that the "capsule description" (on the product listing page) could be handled by the "display:none;" method - that's definitely doable. But I still need the separation on the product detail page - which (like you said ;) ) would be great if I could have the additional field.

I've actually been playing with this, and I've gotten a bit of it to work - I can get the fields to show up in the admin panel, but I'm having an issue getting the information intered into the new form fields to pass to the new database fields I made for them.

Basically, I went into my database and went into the "zen_products_description" table. I added two new fields, and set them up exactly like the original "products_description" field (products_description2 and products_description3). I've gotten the fields - like I said - to show up in the admin panel, no problem. But I'm having an issue getting any input placed in the two new form fields to pass to the database fields. I'm working on admin/functions/general.php, and trying to get this section to get coded properly to do 3 fields at once:

  function zen_get_products_description($product_id, $language_id) {
    global $db;
    $product = $db->Execute("select products_description 
                             from " . TABLE_PRODUCTS_DESCRIPTION . "
                             where products_id = '" . (int)$product_id . "'
                             and language_id = '" . (int)$language_id . "'");

    return $product->fields['products_description'];

}

This is on a localhost server, by the way, and I'm just "playing" - so if I screw anything up majorly, it won't be a big deal ;) I'm not that great at MySQL stuff, so what I've tried is all "trial and error" - but if there's any clue how to get the 3 form fields to pass the information to the proper database fields, that would rock. I htink I could figure out the rest from there - I just need to get the info into the database.