I have tried over and over to get a very simple query to work. Its part of login sequence, but any time I use the 'WHERE' clause it returns an empty set. For example
SELECT email, password FROM `users`
will work. But this fails :
SELECT email,password FROM `users` WHERE email='stevebushe@gmail.com'
Using TRIM or using replace() to make sure there are no spaces,line breaks or returns. I'd appreciate any help, this little problem has held me up for days.
Solved it. The issue was quotation marks. Used concat and trim together to change the values in 'email' column and now everything works.