execute('delete from ' . TABLE_PRODUCTS_XSELL . ' where xsell_id = "'.$temp_prod.'" and products_id = "'.$_GET['add_related_product_ID'].'"'); } } $sort_start_query = $db->execute('select sort_order from ' . TABLE_PRODUCTS_XSELL . ' where products_id = "'.$_GET['add_related_product_ID'].'" order by sort_order desc limit 1'); // $sort_start = mysqli_fetch_array($sort_start_query); $sort_start = $sort_start_query->fields ; $sort = (($sort_start['sort_order'] > 0) ? $sort_start['sort_order'] : '0'); if ($_POST['cross']){ foreach ($_POST['cross'] as $temp){ $sort++; $insert_array = array(); $insert_array = array('products_id' => $_GET['add_related_product_ID'], 'xsell_id' => $temp, 'sort_order' => $sort); zen_db_perform(TABLE_PRODUCTS_XSELL, $insert_array); } } $messageStack->add(CROSS_SELL_SUCCESS, 'success'); break; case 'update_sort' : foreach ($_POST as $key_a => $value_a){ $db->execute('update ' . TABLE_PRODUCTS_XSELL . ' set sort_order = "' . $value_a . '" where xsell_id = "' . $key_a . '"'); } $messageStack->add(SORT_CROSS_SELL_SUCCESS, 'success'); break; } ?> > <?php echo TITLE; ?>
execute($products_query_raw) or die(mysql_error()); ?> EOF) { $products = $products_query->fields ; ?> "> MoveNext(); } ?>
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>
         execute('select p.products_id, p.products_model, pd.products_name, p.products_id, x.products_id, x.xsell_id, x.sort_order, x.ID from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd, '.TABLE_PRODUCTS_XSELL.' x where x.xsell_id = p.products_id and x.products_id = "'.$products['products_id'].'" and p.products_id = pd.products_id and pd.language_id = "'.(int)$languages_id.'" order by x.sort_order asc'); $i=0; while (!$products_cross_query->EOF){ $products_cross = $products_cross_query->fields ; $i++; ?> MoveNext() ; } if ($i <= 0){ ?>
 ' . $products_cross['products_model'] . ' ' . $products_cross['products_name'];?> 
 No cross sell products 
     0) ? ''.TEXT_SORT.' ' : '--')?>
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>
execute('select pd.products_name, p.products_model, p.products_image from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = "'.$_GET['add_related_product_ID'].'" and p.products_id = pd.products_id and pd.language_id ="'.(int)$languages_id.'"'); //$products_name = mysqli_fetch_array($products_name_query); $products_name = $products_name_query->fields ; //['products_name']; ?> execute($products_query_raw); ?>
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>
EOF) { $products = $products_query->fields ; $xsold_query = $db->execute('select * from '.TABLE_PRODUCTS_XSELL.' where products_id = "'.$_GET['add_related_product_ID'].'" and xsell_id = "'.$products['products_id'].'"'); // $xsold_count = $xsold_query->fields ; $xsold_count = $xsold_query->RecordCount() ; ?> MoveNext() ; } ?>

' . zen_image_button('button_cancel.gif') . '

' . zen_image_button('button_back.gif', IMAGE_BACK) . '';?>
                 
       No Image
');?> 		   0) ? true : false), '', ' onMouseOver="this.style.cursor=\'hand\'"');?>       format($products['products_price']);?> 
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>
execute('select pd.products_name, p.products_model, p.products_image from '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_DESCRIPTION.' pd where p.products_id = "'.$_GET['add_related_product_ID'].'" and p.products_id = pd.products_id and pd.language_id ="'.(int)$languages_id.'"'); // $products_name = mysqli_fetch_array($products_name_query); $products_name = $products_name_query->fields ; // ['products_name']; ?> $i, 'text' => $i); } $products_query = $db->execute($products_query_raw); ?>
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>
EOF){ $products = $products_query->fields ; ?> MoveNext() ; } ?>

' . zen_image_button('button_cancel.gif') . '';?>
                 
       '.TEXT_NO_IMAGE.'
');?> 		     format($products['products_price']);?>    
display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?>