Creating a Table with User and Psw

[luitron]

I have this loging script and all i need is to create a table like this:
+----+----------+------------------+
| id | username | password |
+----+----------+------------------+
| 1 | john | 2ca0ede551581d29 |
| 2 | joe | 7b57f28428847751 |
| 3 | tom | 675bd1463e544441 |
| 4 | bill | 656d52cb5d0c13cb |
+----+----------+------------------+

please any help will do

[liquedus]

create table yournamehere (id int auto_increment primary key, username varchar(20), password varchar(50))

and i am guessing that all the passwords have to be md5'ed

hope that helps

[luitron]

thanks that helps alot

[patna_in]

Now how i match this password with a password given by a php driven site.

[Alexei Kubarev]

the password that you are getting from a user should be md5 encoded.. then you simply try to selelct the user with that use4rname and that md5 encoded password... in case you get 0 rows: wrong username or password error should be thrown..