help selecting records

[rockindano30]

Hello all

 

i'm having a little difficulties with this sql syntax.

 

SELECT * FROM users WHERE Uname='user1' and Pword='user1';

 

with the above sql syntax it returns 0 records

 

and with

 

SELECT * FROM users WHERE Uname='user1';

 

it returns one record. now i have two records in this database but having this problem.

 

please help.

[BlueSkyIS]

is there any record in the database where Uname='user1' and Pword='user1'?

[rockindano30]

yes, there are two records that im using for testing. it does display it the record with

 

select * from users where Uname='user1';

 

but not with

select * from users where Uname='user1' and Pword='user1';

 

 

[rockindano30]

or it doesn't even display any records also if i use

 

select * from users where Pword='user1';

 

im using MD5() to encrypt the Pword when its being add into db

[rockindano30]

why won't this give me or show me my records?

 

SELECT * FROM users WHERE Uname='{$Uname}' AND Pword='{$Pword}';

 

 

[rockindano30]

no help? 

[revraz]

You know, making another post about the same topic doesn't help, it actually makes it worse.

[DarkWater]

You need to check the MD5 of the entered password with the MD5 in the database.  So, run MD5() on the incoming password and use that in the SQL.