Registration Form

[dpimatrix]

Need to know if there is a sample code out there that I could use for this one
Customer Interaction with the application
1.1 Registering with the system
Customer provides their credit card number or other acceptable tenders and the name associated with it:
1.1.1 Select between visa, MasterCard, discover, and PayPal
1.1.2 Enter Credit Card Number
1.1.3 Enter Expiration Date
1.1.4 Enter Name exactly as appeared on the account
1.1.5 Enter physical address where credit card bills are sent
1.1.6 Enter e-mail address
1.1.7 Enter password (twice)
1.1.8 Enter primary phone number (home or mobile phone)
1.1.9 Click Submit

Need to know if there is a sample code out there that I could use for this one! Thanks for your time

[OuTCasT]

This is a pretty simple insert query question.

[dpimatrix]

I understand that it is a very simple INSERT functions. But there is a little bit more to it than that:

1. When the customer selects VISA, MasterCard, or Discover, he/she gets a field that accepts no more than 16 digits.
2. When the customer selects paypal, he/she gets a field that accepts input in the format of [e-mail]
3. When the customer selects e-Check, he/she gets a field just for a limited amount of digits.

4. After all other information are entered, an e-mail is sent to the customer which he/she must click on to activate the account.

Instead of writing everything from scratch, I wonder if there is a code someone might which I may re-use.

I am new to sql.

Thanks for the help

Ps

[OuTCasT]

This is not a SQL question but anyways. You could set the fields according to your selections. Set the max characters for the textbox if you want to.

The email part of it is also very easy. Use the SMTP function to send the email.
Add a field to the DB called Activated and set it to NO. When the client clicks on the link then you can set the activated to yes according to the ID of the client in the email.

[dpimatrix]

OutCast:

What do you mean by this is not an SQL question? Should I be doing this with a different utilitty?

[ck9663]

He means your question is more of a front-end tasks than a back-end one.

-- CK