RE: Is it possible?

Johnson <[email protected]> 13 Sep 2003 07:54:31 -0000
Newsgroups gmane.comp.web.oscommerce.installation
Message-ID <d912d11fdc7f0d4c65abe215113cdc37@osCommerce-Forums>
This message was sent from: Installation and Configuration
http://forums.oscommerce.com/viewtopic.php?p=228805#228805
----------------------------------------------------------------

essentially, anywhere that you find products_description, you must duplicate with more_info.

Here is an example of select and insert:

[code]            $description_query = tep_db_query("select language_id, products_name, products_description, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'");
            while ($description = tep_db_fetch_array($description_query)) {
              tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0')");
            }[/code]