Mysql table and strange problem

Hi
I am using phpMYAdmin to create the Mysql tables but i am facing strange proble(atleast for me it is strange) with one table called User,I have two fields in this table 'user' and 'password'. problem is this that i can add data using php form but when user try to login through php form, it is reading just first row,if i try to log in as other users with their password, i get the message that it is wrong password but if i try to login as other users with the first user's password i can login as first user and i cannot understand why is this happening can any one help me out please because i dont have a clue what is going on here
SQL query for the User table is
[code]
# Table structure for table `USER`
#

CREATE TABLE USER (
User varchar(20) NOT NULL default '',
password varchar(200) NOT NULL default '',
PRIMARY KEY (User)
) TYPE=MyISAM;
[/ode]

Could you post the code you are using to get the login details off the user and the code you are using to check those details against the database.

Thanks

hi

thank u for ur help, infact when i was copingy code for u i just realised that i have used


instead of


problem is solved now
can u help me to decide something else as well
i want to set limited number of trying if someone has entered wrong password. can u give me idea how i can do it please

I'd set a session variable - say login_count - if they fail the login increment the login_count... if they suceed reset it.

Before you display the login form .. or whatever you have ... check the value and if it equals or is greater than your limit then give them a message they have to wait otherwise present the login form to them.

thank u i ll try that on weekend an email problems on the forum.