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 ?
gjb [ So, 02 April 2006 21:47 ] [ ID #1257033 ]

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

hi, did u insert the data into database? ues the INSERT INTO tablename
fieldname....values (values,....);
visit2imran [ Mo, 03 April 2006 09:33 ] [ ID #1258333 ]

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

Did u insert the data into the database ? IF not first insert the data.
visit2imran [ Mo, 03 April 2006 09:34 ] [ ID #1258334 ]

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?
<visit2imran [at] gmail.com> wrote in message
news:1144049677.230869.138220 [at] i40g2000cwc.googlegroups.com.. .
> Did u insert the data into the database ? IF not first insert the data.
>
gjb [ Mo, 03 April 2006 20:43 ] [ ID #1258344 ]
PHP » alt.php.sql » PHPmyadmin, creating user details for a database....

Vorheriges Thema: select * where a=1 if b=3
Nächstes Thema: Setting up Apache2 (Test Server on localhost) for email