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
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
Thanks,
KWW
any help with this???
Thanks,
KWW
How are you wanting to use this?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
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.
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
Thanks,
KWW
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.
Thanks,
KWW
I need a specific query to get the info I need
Thanks,
KWW
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]
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
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.....
Thanks,
KWW
ok, i tried the query, but i got an error saying: bad handshake
Thanks,
KWW
Bookmarks