Preserved Topic: Customer Database

Ok, so I am ready to Rock and Roll.. everything is in place, orders went good on testing phase.. now the organization problem...

I would need to have some kind of database that will let my customers check their billing stuff...For example, they would log in with their user ID and password and would be able to see their billing.

I can export MY credit billing to MS Excel via my merchant control panel.. now I just need to figure out the way to let my clients to be able to see it... so what do you guys recommend? Should I use asp or something like that?



MAX

Anyone?

MAX

Well, I don't have any info but I am not sure that I would want people to be able to see what I owe. Know what I mean? If it is a business that you deal with then they should have their own Accounts Payable department that keep track of what they owe.

Now, if you were wanting your clients to be able to see what kind of service they have and be able to upgrade or switch something then that is a different story.

I don't know how you would handle this. Maybe contact Ini or mr.maX via email and they could possibly help. I think that Zox and Bitdamaged are really good at that kind of thing as well.

Sorry I couldn't be any help, I just now saw this thread.

Later,
C:\


~Binary is best~

Not exactly sure how you'd do it, but I bet it could be done in PHP/MySQL

You are right Pugzly, it can be done with MySQL.. the only problem is that I have no clue about database development...I was thinking maybe do some kind of database in Access (I would have to learn that too) and then I could pull it with SQL??? am I going in the right direction here?


The idea of it is that I would want to have my clients to be able to log on on certain page on my website and when they input their user name and password (which is emailed to them) it would automatically take them to their "billing" page where they could see different information about their invoice and billing history...You know what I mean?

I understand that I need support on the server for this kind of thing. I can use either MySQL, PHP4, Perl5, TCL ( no clue what the hell that is)

I guess my first step would be to create a log on page right? That page would't require clients to register. They would be inputed into database before.

How oh how can I do this???????

Can someone point me to some tutorials? anything...maybe some cheap software? I would pay for someone to develop this system for me also...

MAX

Well, from what I know (which my wife would say is "very little"), PHP/MySQL is the way to go. I think you'd probably find the most support for that as well. Getting data into and out of a database usually isn't that difficult. Verifying, manipulating, and importing is another story.