Creating a Table with User and Psw

[Anonymous]

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

 

[Anonymous]

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

 

[Alexej 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..