Clinton Posted June 7, 2008 Share Posted June 7, 2008 I need to set my query with two WHERE clauses. What's wrong with the code below? SELECT * FROM masterlist WHERE producttype = 'MS NONEL' AND delete = '0' ORDER BY datecode Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted June 7, 2008 Share Posted June 7, 2008 delete is a reserved word in mysql. Either place backticks(`) around the fieldname or (better) rename your field. Quote Link to comment Share on other sites More sharing options...
Clinton Posted June 7, 2008 Author Share Posted June 7, 2008 Forgot about those reserved words. That was the problem. Thank you. 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.