BigD Posted August 23, 2012 Share Posted August 23, 2012 I have a sql $query = "SELECT score FROM test where classid = $classid, stdid = $stdid, testname = 'M&M'";It failed syntax check because the & in M&M. M&M is the actural value stored in my DB testname field.How do I escape & ? Link to comment Share on other sites More sharing options...
JamesB Posted August 23, 2012 Share Posted August 23, 2012 i'm pretty sure the & character doesn't need escaping:http://dev.mysql.com/doc/refman/5.6/en/string-literals.html try changing the commas to AND or OR. Link to comment Share on other sites More sharing options...
BigD Posted August 24, 2012 Author Share Posted August 24, 2012 You are right and thanks, James. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now