List Prices
= require 'includes/application_top.php';
require language::map_to_translation('list_price.php')
?>
= HEADING_TITLE ?>
=
$categories_name = '';
$list_price_query = $db->query("select c.categories_id, c.categories_name, p.products_id, p.products_model, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name, m.manufacturers_id, m.manufacturers_name from products p left join manufacturers m on m.manufacturers_id = p.manufacturers_id, products_description pd, categories_description c, products_to_categories pc where p.products_id = pd.products_id and p.products_id = pc.products_id and p.products_status = 1 and pc.categories_id = c.categories_id AND c.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "'" . " order by c.categories_id, pd.products_name ASC");
while ($list_price = mysqli_fetch_array($list_price_query)) {
if($categories_name != $list_price['categories_name']) {
?>
= TABLE_HEADING_IMAGE ?> |
= TABLE_HEADING_PRODUCTS ?> |
= TABLE_HEADING_MODEL ?> |
= TABLE_HEADING_MANUFACTURER ?> |
= TABLE_HEADING_PRICE ?> |