<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
