Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Display More In Admin Customers


Sethman

Recommended Posts

I want to add a column to the admin/customers.php page that displays the customers company name.

 

I have been able to get the actual column to appear, but what would be the code necessary to call the company name to be displayed?

 

Anyone?

Link to comment
Share on other sites

I want to add a column to the admin/customers.php page that displays the customers company name.

 

I have been able to get the actual column to appear, but what would be the code necessary to call the company name to be displayed?

 

Anyone?

 

add the field to the query select statement and echo it out in the column

Treasurer MFC

Link to comment
Share on other sites

Add "a.entry_company" to this query (around line 719 in admin/customers.php):

    $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname";

Link to comment
Share on other sites

sorry to bug again...

 

what about on admin/orders.php?

 

I'm having the same problem... got the column to display, but can't find the right sql to call the customers company

 

thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...