display shipping total in Admin/orders

[JohnW]

Hi All,

I'm trying to display the shipping total for each order along with the other information in the Admin panel/customers/orders. However, I'm not succeeding and the best I can get is a "S" being displayed on each line for shipping. I've tried a number of different things but I'm not getting it, so I'm hoping for a little help from someone that understands coding better.

Here's what I have at this time in orders.php

<?php  
$shipping_total = 'SELECT `value` FROM `orders_total` WHERE `class` LIKE \'ot_shipping\' ORDER BY `orders_id` DESC';
?>	

                <td class="dataTableContent" align="center"><?php echo strip_tags ($shipping_total['value']) ?></td>

That query will work to display in PhPmyAdmin, but it's not working here.

Any guidance is appreciated.

[JohnW]

I don't know if anyone else wants to display this but this is how I got it to work

<?php  
$shipping_total = "SELECT text".
                  "  FROM orders_total".
				  " WHERE class = 'ot_shipping' ".
				  "   AND orders_id = ". $orders['orders_id'].
				  " ORDER BY orders_id DESC";
	$shipping_query_01 = tep_db_query($shipping_total);
    $shipping_query_02 = tep_db_fetch_array($shipping_query_01);
?>	

                <td class="dataTableContent" align="center"><?php echo $shipping_query_02['text']; ?></td>