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]