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
Post a Comment