php - where clause returns empty set even when using trim -


i have tried on , on simple query work. part of login sequence, time use 'where' clause returns empty set. example

select email, password `users` 

will work. fails :

select email,password `users` email='stevebushe@gmail.com' 

using trim or using replace() make sure there no spaces,line breaks or returns. i'd appreciate help, little problem has held me days.

solved it. issue quotation marks. used concat , trim change values in 'email' column , works.


Comments

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

javascript - oscilloscope of speaker input stops rendering after a few seconds -