Help with some database changes please

[warrenerjm]

Hi

 

I am changing the address_format table to show UK address. That's ok as I have changed number 1 to this

 

$firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

I have added a new field in customers table of customers_title so I also need to add this to the above as their title is not showing in the invoice.

 

I have tried

 

Stitle $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

Scustomers_title $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

but the title still doesn't show, on new invoices created!

I have checked catalog/admin/invoice.php but it is calling the database info.

 

So please what am I missing?

 

Thanks

Julie

[Guest]

Can you show us the sql statement that you are using for the invoice?

[warrenerjm]

Can you show us the sql statement that you are using for the invoice?

Hi Beau

 

Do you mean this line that is in the invoice.php file?

 

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>

 

Julie

[jonquil]

This may sound really obvious or a typo when you posted...

 

Stitle $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

Scustomers_title $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

They should be $ instead?

[warrenerjm]

This may sound really obvious or a typo when you posted...

 

Stitle $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

Scustomers_title $firstname $lastname$cr$streets$cr$city$cr$states$cr$postcode$cr$country

 

They should be $ instead?

Opps sorry that was a typo :blush: I have used the $ in the database

Julie