PHPmyadmin, creating user details for a database....

Hello
I have a problem with a database for a simple login page, where a user needs
a username and password. I've created the database and the table using

CREATE TABLE users (
username varchar(20) NOT NULL default '',
password varchar(20) NOT NULL default ''
);

but I'm stuck as to where I create the information for usernmane and
passwords. I've searched google and tried numerous commands, is it right I
use the CREATE USER ?

Re: PHPmyadmin, creating user details for a database....

hi, did u insert the data into database? ues the INSERT INTO tablename
fieldname....values (values,....);

Re: PHPmyadmin, creating user details for a database....

Did u insert the data into the database ? IF not first insert the data.

Re: PHPmyadmin, creating user details for a database....

INSERT INTO users (username,password) VALUES(admin),(password)

like this? to create a user with admin / password?
wrote in message
news:1144049677.230869.138220@i40g2000cwc.googlegroups.com.. .
> Did u insert the data into the database ? IF not first insert the data.
>