selecting my records

[rockindano30]

hello all,

 

i have a problem.

 

this line here says that i have 0 records

 

SELECT * FROM users WHERE Uname='user1' AND Pword='user1'

 

but i realy have on record with user name (Uname) user1 and Password (Pword) user1

 

but if i do this it does show my record

 

SELECT * FROM users WHERE Uname='user1';

 

and it also says that i have 0 records if i use

 

SELECT * FROM users WHERE Pword='user1';

 

any help?

[mezise]

It might be a typo or whitespace character at the beginning or at the end of Pword value.

 

My advice is that you should not use unencrypted way of storing passwords.

[fenway]

Databases don't lie... if that's what it says, that's what it is... but I depends how you're "counting" the records.  What's "it"?