Arthur Posted September 23, 2002 Share Posted September 23, 2002 I want to know when these 2 tables are updated - address_book and customers. If a shopper/surfer registers, then the customers table will be updated. Will the address_book be usdated at the same time or does the shopper/surfer need to explicitly request the address_book to be updated? I am building a small stand-alone module out of this information. Many thanks Arthur Link to comment Share on other sites More sharing options...
Mark Evans Posted September 23, 2002 Share Posted September 23, 2002 I want to know when these 2 tables are updated - address_book and customers. If a shopper/surfer registers, then the customers table will be updated. Will the address_book be usdated at the same time or does the shopper/surfer need to explicitly request the address_book to be updated? The customers table is updated when the user first registers. The address book table is updated then the account is first created when the user registers and then whenever they add / remove an address or edits the address that they entered when they registered. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds) Link to comment Share on other sites More sharing options...
Arthur Posted September 23, 2002 Author Share Posted September 23, 2002 I want to know when these 2 tables are updated - address_book and customers. If a shopper/surfer registers, then the customers table will be updated. Will the address_book be usdated at the same time or does the shopper/surfer need to explicitly request the address_book to be updated? The customers table is updated when the user first registers. The address book table is updated then the account is first created when the user registers and then whenever they add / remove an address or edits the address that they entered when they registered. Thanks Mark Just to make sure, if I set up my SQL customers_id = customers_id and address_book_id = '1', then I could be sure to get all info for that particular customer? I am correct about this? Arthur Link to comment Share on other sites More sharing options...
Mark Evans Posted September 23, 2002 Share Posted September 23, 2002 Just to make sure, if I set up my SQL customers_id = customers_id and address_book_id = '1', then I could be sure to get all info for that particular customer? I am correct about this?Arthur That will get you the default address for a customer not all of the addresses if they have entered more than one. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds) Link to comment Share on other sites More sharing options...
Arthur Posted September 23, 2002 Author Share Posted September 23, 2002 Just to make sure, if I set up my SQL customers_id = customers_id and address_book_id = '1', then I could be sure to get all info for that particular customer? I am correct about this? Arthur That will get you the default address for a customer not all of the addresses if they have entered more than one. Thanks again, I think the default address is what I need. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.