osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

display shipping total in Admin/orders

This is a discussion on display shipping total in Admin/orders within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Hi All, I'm trying to display the shipping total for each order along with the other information in the Admin ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 06-23-2006, 11:54 AM
osCMax Testing Team
 
Join Date: Nov 2002
Location: Orlando
Posts: 201
Thanks: 10
Thanked 26 Times in 14 Posts
Rep Power: 7
JohnW will become famous soon enoughJohnW will become famous soon enough
Default display shipping total in Admin/orders

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
Code:
<?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.
__________________
John
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 06-26-2006, 02:04 PM
osCMax Testing Team
 
Join Date: Nov 2002
Location: Orlando
Posts: 201
Thanks: 10
Thanked 26 Times in 14 Posts
Rep Power: 7
JohnW will become famous soon enoughJohnW will become famous soon enough
Default RE: display shipping total in Admin/orders

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

Code:
<?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>
__________________
John
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Admin orders - Display more characters in Model# field?? JonCloud420 osCMax v2 Features Discussion 1 10-19-2006 08:06 PM
How do I display the Final Order Total? mikestollov osCommerce 2.2 Discussion 2 03-21-2006 03:55 PM
Help! Lost Shipping and Order Total modules.. Picman osCommerce 2.2 Installation Help 1 05-22-2004 06:34 PM
shipping total help Raysworld osCMax v1.7 Discussion 0 03-02-2004 08:10 AM
Displaying ONLY item total but not currency in cart display humbags osCommerce 2.2 Modification Help 0 07-12-2003 02:41 AM


All times are GMT -8. The time now is 08:53 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax