error 1054 (need database help)

[cowcents]

Hello All,

 

I have been trying to add 'Company Type' to my customer info page. I think I have it all sorted out, but I need this info to show up in my admin. I have that sorted out too (I think) except I get:

 

1054 - Unknown column 'a.entry_company_type' in 'field list'

 

select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_company_type, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '32'

 

[TEP STOP]

 

I am guessing that I need to add this extra field to my database...Right?

 

I have tried to research online how to do this, but I can't find to much useful info.

 

Any help would be greatly appreciated....

 

Thanks!

 

Chantal

[♥geoffreywalton]

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on Address book

 

5) Now you can add the field, make it the size you want etc

 

http://www.w3schools.com/sql/default.asp

 

Enjoy

[cowcents]

Thanks for that, now I have that fixed and it is logging somewhat, but still have some error, but your help was great!