MySQL Forums
Forum List  »  PHP

Re: Query with PHP variables not returning correct result.
Posted by: Richard Dunne
Date: March 21, 2015 04:49AM

I have tested the query in the MySQL client using (=) and 'like', and the actual email address and both work fine, return the correct result, telling me nothing.
The problem is the query as is cannot be tested in the MySQL client as is it uses PHP variables. The query works fine without the where clause firstly, so, given no syntax errors, the query is not matching the email address contained in the $Email variable with the email address contained in the Email column (varchar (50) InnoDB). The only thing I can come up with is this (using Occam's razor) which I am investigating (not Occam's Razor) is a php setting interfering.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.