List company in costumers.php

[[email protected]]

Does anyone know how to add company to the listing in customers.php ?

Right know only Lastname, Firstname, Account_created, Action ist listed, but I want Company to be listed to.

How?

I need an answer quick...please

[Guest]

Add an extra heading column & data for the html code Then modify the query line to retrieve the customers address from the address_bood table.

 

Your query should be like this:

$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_company, 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";

 

then when you access it use $customers['entry_company']

[[email protected]]

Does anyone know how to add company to the listing in customers.php ?

Right know only Lastname, Firstname, Account_created, Action ist listed, but I want Company to be listed to.

How?

I need an answer quick...please

<{POST_SNAPBACK}>

 

I fixed it myself !!

[OSCnewbie]

I fixed it myself !!

<{POST_SNAPBACK}>

 

Could you tell me what you did to fix it?

 

I would like to add some additional fields to customer information too (I need between 5 - 8 extra fields)??

 

Thanks for anyone's help.

 

:D