need help with addresses

[keystonewebworks]

please help with this:

I need a database query to give me the following:

1. mr/mrs
2. first name
3. last name
4. address 1
5. address 2
6. City
7. State
8. Zip
9. Country


Any help with this please

[keystonewebworks]

any help with this???

[DrByte]

How are you wanting to use this?

[jammin320]

I don't know how you want to restrict this query, but all of the information that you are looking for is in the address_book table. I would do a select all from address_book where customers_id is the person you are looking for.

[keystonewebworks]

I am using 1.3.5, it shows the entry id, but not the state.

Example:

Entry ID: 51, State:Nothing Listed in the DB

[keystonewebworks]

I want to use this to generate a mail merge list, of the newletter subscribers, so that I can send them my newletter in the mail.

[keystonewebworks]

I need a specific query to get the info I need

[DrByte]

How about something like this:
http://www.zen-cart.com/forum/showth...949#post249190

... with an additional entry in your WHERE clause about
[FONT="Courier New"]c.customers_newsletter = 1[/FONT]

[keystonewebworks]

kind of hard to follow.....the problem is this:

Address_book table has states in as #'s not as state names, so i need to reference the zone table as well.....entry_code.

I was hoping for a complete query to do this.....

[keystonewebworks]

ok, i tried the query, but i got an error saying: bad handshake