Click to See Complete Forum and Search --> : Creating a Customer data Base ????


NeedsGoodAdvice
11-28-2007, 10:43 PM
Hi Everybody

Creating a Customer data Base ????

I have a few e-commerce websites and would like to create a data base of sorts that is set up like this ...

I would like to be able to have the data base set up so that whenever someone makes a purchase , I can enter them into the data base , ie: Name address , City state zip and what they purchased , how much they spent in $$$ and any notes or additional info etc etc ., I would also like to be able to search on a particular customers name and see if they've purchased from us and when ... To further explain ... You know how when you call a company that you have brought something from and they ask for your name and can pull up your info , well thats what I would like to be able to do .

I have tried using that windows data base thing which is a nightmare to try to work with .

Is there any sort of software or program that enables me to create this type of data base ????

Thanks in advance for any replies and input .

ray326
11-29-2007, 12:05 AM
Any good relational database manager will do. That's normally SQL Server in Windows, MySQL or PostgreSQL in Linux, DB2, Oracle. Many choices. You'll need at least two tables. One for the user info and one for the transaction info.