Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

please help quick syntax error


myshipper

Recommended Posts

589 Is where i get the error

 

$product_query = tep_db_query("select products_quantity, products_model, products_image, products_image_seo_name, products_mediumimage, products_mediumimage_seo_name, products_largeimage, products_largeimage_seo_name, products_image_sm_1, products_image_sm_1_seo_name, products_image_xl_1, products_image_xl_1_seo_name, products_image_sm_2, products_image_sm_2_seo_name, products_image_xl_2, products_image_xl_2_seo_name, products_image_sm_3, products_image_sm_3_seo_name, products_image_xl_3, products_image_xl_3_seo_name, products_image_sm_4, products_image_sm_4_seo_name, products_image_xl_4, products_image_xl_4_seo_name, products_image_sm_5, products_image_sm_5_seo_name, products_image_xl_5, products_image_xl_5_seo_name, products_image_sm_6, products_image_sm_6_seo_name, products_image_xl_6, products_image_xl_6_seo_name, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id, , vendors_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "' tep_db_input($products_id) . "'");

587: $product = tep_db_fetch_array($product_query);

588:

589: tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_image, products_image_seo_name, products_mediumimage, products_mediumimage_seo_name, products_largeimage, products_largeimage_seo_name, products_image_sm_1, products_image_sm_1_seo_name, products_image_xl_1, products_image_xl_1_seo_name, products_image_sm_2, products_image_sm_2_seo_name, products_image_xl_2, products_image_xl_2_seo_name, products_image_sm_3, products_image_sm_3_seo_name, products_image_xl_3, products_image_xl_3_seo_name, products_image_sm_4, products_image_sm_4_seo_name, products_image_xl_4, products_image_xl_4_seo_name, products_image_sm_5, products_image_sm_5_seo_name, products_image_xl_5, products_image_xl_5_seo_name, products_image_sm_6, products_image_sm_6_seo_name, products_image_xl_6, products_image_xl_6_seo_name, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, , vendors_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_image_seo_name']) . "', '" . tep_db_input($product['products_mediumimage']) . "', '" . tep_db_input($product['products_mediumimage_seo_name']) . "', '" . tep_db_input($product['products_largeimage']) . "', '" . tep_db_input($product['products_largeimage_seo_name']) . "', '" . tep_db_input($product['products_image_sm_1']) . "', '" . tep_db_input($product['products_image_sm_1_seo_name']) . "', '" . tep_db_input($product['products_image_xl_1']) . "', '" . tep_db_input($product['products_image_xl_1_seo_name']) . "', '" . tep_db_input($product['products_image_sm_2']) . "', '" . tep_db_input($product['products_image_sm_2_seo_name']) . "', '" . tep_db_input($product['products_image_xl_2']) . "', '" . tep_db_input($product['products_image_xl_2_seo_name']) . "', '" . tep_db_input($product['products_image_sm_3']) . "', '" . tep_db_input($product['products_image_sm_3_seo_name']) . "', '" . tep_db_input($product['products_image_xl_3']) . "', '" . tep_db_input($product['products_image_xl_3_seo_name']) . "', '" . tep_db_input($product['products_image_sm_4']) . "', '" . tep_db_input($product['products_image_sm_4_seo_name']) . "', '" . tep_db_input($product['products_image_xl_4']) . "', '" . tep_db_input($product['products_image_xl_4_seo_name']) . "', '" . tep_db_input($product['products_image_sm_5']) . "', '" . tep_db_input($product['products_image_sm_5_seo_name']) . "', '" . tep_db_input($product['products_image_xl_5']) . "', '" . tep_db_input($product['products_image_xl_5_seo_name']) . "', '" . tep_db_input($product['products_image_sm_6']) . "', '" . tep_db_input($product['products_image_sm_6_seo_name']) . "', '" . tep_db_input($product['products_image_xl_6']) . "', '" . tep_db_input($product['products_image_xl_6_seo_name']) . "', '" . tep_db_input($product['products_price']) . "', now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . $product['manufacturers_id'] . "')");

590:

591: $description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'");

592: while ($description = tep_db_fetch_array($description_query)) {

593: tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, 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_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')");

594: }

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...