pls see the message

say me how to set/create field for these in Myphpadmin.database

I want to create a register form,so first i have to create field in Myphpadmin.database
,how?

Waiting for ur reply.

1)username
2)first name
3)lastname
4)password
5)confirm password
6)date of birth -(date -month-year)
7)gender
8)alternate email
9)country -(selecting country)

regards
riyaz.

 

CREATE TABLE 'users' (
'id_user' INT NOT NULL AUTO_INCREMENT ,
'name' VARCHAR( 128 ) NOT NULL ,
'lastname' VARCHAR( 128 ) NOT NULL ,
'email' VARCHAR( 64 ) NOT NULL ,
'alternative' VARCHAR( 64 ) NOT NULL ,
'country' VARCHAR( 64 ) NOT NULL ,
'username' VARCHAR( 16 ) NOT NULL ,
'password' VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY ( 'id_user' )
)

Like this?

 

Thanks,so kind of you, one last favour would u send same for(date of birth,image verification).

i will be waiting for ur reply.

 

add a date of birth field in the above example.

the image verification (aka CAPTCHA) doesn't have anything to do with database. you do on your page. there are many available for free.

here's a good one in PHP:

http://www.phpcaptcha.org/

Code (markup):

 

Thankx for the message,

what i should select in (type field box and default box) for date of birth

pls let me know.

 

'date' VARCHAR( 10 ) NOT NULL

 

thanks for the message, Can i keep ( Default .timestamp)

because i have list menu for date of birth.

 

there are 2 way to create a database in mysql
1) using command prompt.
2)using phpadmin.
where u specify ur field name that you gives.