Hello, currently I am trying to show the products quantity on order right after $order->products[$i]['qty'] I want to see the exact quantity avaliable in stock.

Something like this:

Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)
1 from 25 x Russell Hobbs RH18521 / 1800W RH18521 0% 99,00$ 99,00$. 99,00$ 99,00$

The code I added to admin->orders.php is:

PHP Code:
<?php $products_qty_raw = ("select p.products_quantity,o.orders_products_id, o.products_id, p.products_id
                                from " 
TABLE_PRODUCTS " p, " TABLE_ORDERS_PRODUCTS " o                            
                                where p.products_id = o.products_id
                                and orders_id = " 
. (int)$order_id ""
                                
);
                                
$pqty 'p.products_quantity';
                                
?>
and after that i used $pqty to show the current stock but nothing happens.

Any help is Appreciated.