webref.eu Posted March 13, 2009 Share Posted March 13, 2009 Hi All I need help from experts to modify this SQL query: $query = "select * from Users where Username like \"%$trimmed%\" order by Username"; To also search the Email field of my data, i.e. not just the Username field. This is what I've tried so far, and it doesn't work: $query = "select * from Users, Email where (Username like \"%$trimmed%\" OR Email like \"%$trimmed%\") order by Username"; Can you help? Many thanks Quote Link to comment Share on other sites More sharing options...
webref.eu Posted March 13, 2009 Author Share Posted March 13, 2009 OK guys, I worked it out, I had an error towards the beginning of the statement where I had mentioned Email in error, should be: $query = "select * from Users where (Username like \"%$trimmed%\" OR Email like \"%$trimmed%\") order by Username"; Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.