Re: history file

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43595
interpreted = N
texte = Paul wrote:> Hi > > I would like to make sure that when someone logs onto the website that > all his previous purchases are shown on a user page which he has to log > onto with the username and password he created the first time he joined, > what is the easiest way of doing this?Hi paul, I am sure there is a few ways to do this. I would probably assign an ID to that customer when he/she registers. this ID would probably be in the clients.db file that you have currently.I would probably then create a second database... (order_history.db or something)Then when a customer purchases an order (perhaps on the thankyou page) you can append to this database the ID and the order info. This way, when a user logs in first a query is done (probably a lookup) to the clients.db for the ID. when the ID is found a search is done on the order history with that ID number (if you store the date also you could sort by date). There is a whole slew of things you *could* do though so have fun!.cheers, Donovan> > > Is there a way of adding multiple SKU numbers to his entry in the > clients.db file I have rather than search all the old orders as i would > rather do it this way > > Any help appreciated > > Paul > >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: history file (Donovan 2002)
  2. Re: history file (Paul 2002)
Paul wrote:> Hi > > I would like to make sure that when someone logs onto the website that > all his previous purchases are shown on a user page which he has to log > onto with the username and password he created the first time he joined, > what is the easiest way of doing this?Hi paul, I am sure there is a few ways to do this. I would probably assign an ID to that customer when he/she registers. this ID would probably be in the clients.db file that you have currently.I would probably then create a second database... (order_history.db or something)Then when a customer purchases an order (perhaps on the thankyou page) you can append to this database the ID and the order info. This way, when a user logs in first a query is done (probably a lookup) to the clients.db for the ID. when the ID is found a search is done on the order history with that ID number (if you store the date also you could sort by date). There is a whole slew of things you *could* do though so have fun!.cheers, Donovan> > > Is there a way of adding multiple SKU numbers to his entry in the > clients.db file I have rather than search all the old orders as i would > rather do it this way > > Any help appreciated > > Paul > >-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Donovan

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

PCS Emailer's role ? (1997) Country & Ship-to address & other fields ? (1997) The Guru Speaks-Is That Really the Only Manuel? (1998) New Command prefs ... (1997) WebCat name recognition (1998) Banner Ad example (Typhoon) and WebCatalog (1997) f2 download problems (1997) Bug Report, maybe (1997) Nesting format tags (1997) [OT] On a side note.. (2003) Buying sans cart (1997) WebCommerce: Folder organization ? (1997) authenticating a second user (1997) price carry over (1997) [purchase] (1999) syntax question, not in online refernce (1997) RE: Displaying Location (1997) File not found error message (1998) Show all from database (2001) Not really WebCat (1997)