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:

Save Word/Excel Docs to Server (2002) [table] retained in memory (2006) [UPPERCASE] (1997) Missing from Docs [folderName] (1997) Searching multiple Databases (1997) Line Feed Character Appended (1998) A Global Variable (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebCatalog and Filemaker (1996) [date format] w/in sendmail (1997) Discounts (2002) Putting together a econimic server (2004) plugin-acgi, different results (1997) Sendmail Woes (2002) Template transformed itself into a database? (1998) Writing multiple data into one field (1998) Date Calulation (1997) Criticism of WebCatalog: Keep It Coming! (1998) (1997) Fun with Dates - revisited (1997)