<td class="dataTableHeadingContent" width="75">Product id</td> <td class="dataTableHeadingContent" width="75">Quickfind code</td> <td class="dataTableHeadingContent">Name</td> <td class="dataTableHeadingContent" width="150">Price</td> <td class="dataTableHeadingContent" width="150">Order (1=Top)</td> </tr> <?php $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '" . $add_related_product_ID . APOS; list($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR, $order_PR) = general_db_conct($query); $ordering_size = sizeof($ID_PR); for ($i = 0; $i < $ordering_size; $i++) { $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . "a.products_quantity, a.products_model, a.products_image, " . "b.products_url, a.products_price from " . TABLE_PRODUCTS . " a, " . TABLE_PRODUCTS_DESCRIPTION . " b where b.products_id = a.products_id and b.language_id = '" . $languages_id . "' and a.products_id = " . $xsell_id_PR[$i] . ""; list($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description, $PRODUCTS_quantity, $PRODUCTS_model, $PRODUCTS_image, $PRODUCTS_url, $PRODUCTS_price) = general_db_conct($query); ?> <tr class="dataTableContentRow" bgcolor='#DFE4F4'> <td class="dataTableContent"><?php echo $PRODUCTS_id[0]; ?> </td> <!--// Adam@CP: Added Model Number and image thumbnail. --> <td class="dataTableContent"><?php echo $PRODUCTS_model[0]; ?> </td> <td class="dataTableContent"><?php echo $PRODUCTS_name[0]; ?>
echo HEADING_PRODUCT_NAME; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo HEADING_PRODUCT_ORDER; ?> </td> <td class="dataTableHeadingContent" align="center">Delete</td> </tr> <?php $query = "select * from " . TABLE_ARTICLES_XSELL . " where articles_id = '" . (int) $_GET['add_related_article_ID'] . "'"; list($ID_PR, $products_id_pr, $xsell_id_pr, $order_PR) = general_db_conct($query); $ordering_size = sizeof($ID_PR); for ($i = 0; $i < $ordering_size; ++$i) { $query = "select p.products_id, pd.products_name, pd.products_description, pd.products_url from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . (int) $languages_id . "' and p.products_id = " . $xsell_id_pr[$i] . ""; list($products_id, $products_name, $products_description, $products_url) = general_db_conct($query); ?> <tr class="dataTableRow" onMouseOver="rowOverEffect(this)" onMouseOut="rowOutEffect(this)"> <td class="dataTableContent" align="center"><?php echo $products_id[0]; ?> </td> <td class="dataTableContent"><?php echo $products_name[0]; ?> </td> <td class="dataTableContent" align="center"><select name="<?php echo $products_id[0]; ?> "> <?php