hi . i have successfully installed this amazing/handy/fantastik contribution and the products list nicely under their manufacturer. i also list extra fields per products as author and isbn. from the products table
what i try to do is to display the manufacturer_url from the manufacturers_info table but i cant make the join of the tables at admin/includes/order.php
i have tried to improvise by looking at the manufacturers_info box from the catalog side but i cant understand it
*********************************this is the place that the join has to happen :-)
$orders_products_query = tep_db_query("select op.orders_products_id, op.products_id, op.products_name,products_person, products_isbn, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price, p.manufacturers_id,m.manufacturers_name from " . TABLE_ORDERS_PRODUCTS . " op left join " . TABLE_PRODUCTS . " p on p.products_id = op.products_id left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id = p.manufacturers_id where op.orders_id = '" . (int)$order_id . "' order by p.manufacturers_id");
************************************************************************
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'],
'products_person' => $orders_products['products_person'],
'products_isbn' => $orders_products['products_isbn'],
'name' => $orders_products['products_name'],
'products_id' => $orders_products['products_id'],
'model' => $orders_products['products_model'],
'tax' => $orders_products['products_tax'],
'price' => $orders_products['products_price'],
'id' => $orders_products['products_id'],
'final_price' => $orders_products['final_price'],
'manufacturers_id' => $orders_products['manufacturers_id'],
'manufacturers_name' => $orders_products['manufacturers_name']);
regards from greece
george