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

xslt - Substring before throwing error -

Google Cloud Bigtable Durability/Availability Guarantees -

Android M doze mode and "native" posix socket freezing up -