i need login/signup scripting and database

[gummybear]

Hi,
I am looking for a script which will allow my members to sign up for an account.

When they fill up the form and click submit. They will hav to wait till I manually verify that they have entered correct info. After verifying then only will they be able to login.

I want to do something like this.

But i have no idea on how do create the scripts and databse and any other stuff im really a noob. all i know is that my host has a 4.1x mySQL database

[NogDog]

You'll need to use some sort of server-side programming, such as PHP, ASP, Perl, etc.; so you need to also find out which of those your host supports.

[chazzy]

heh..
having the SQL forum in the server side category is a little ironic.

[gummybear]

i dont understnad

[gummybear]

Ok lets say i have this script which memebers fill out their info and submit it. This form is emailed to my email account. I want to add this account into a database manually

[chazzy]

it'd be a simple insert statement then.

INSERT INTO your_table(col1,col2,col3,...,coln) VALUES('val1','val2','val3',....,'valn');

[gummybear]

where do i insert that i have no clue on SQL PHP

[chazzy]

Check out this link
it's poorly named, but should help you get started
http://php.about.com/
If you have a hosted environment, you should see a tool called "phpMyAdmin" that lets you connect to your database and run queries.

[gummybear]

could u chat with me on MSN?

[chrismartz]

If MySQL has a stored proc area you want to put that in a stored procedure. When you wanto to run it, call that proc to you page and execute it when it needs to be executed. I think using stored procedures will cut down on web server load unless you are running the sql server along side the web server.