coder9 Posted July 27, 2008 Share Posted July 27, 2008 I have this two syntax. Please tell me which is correct syntax. This one? $query = "SELECT * FROM jwinners WHERE prize IN('1', '2', '3', '4', '5')"; or this one? $query = "SELECT * FROM jwinners WHERE prize IN(1, 2, 3, 4, 5)"; prize is an integer column. Thank you. Quote Link to comment Share on other sites More sharing options...
MFHJoe Posted July 27, 2008 Share Posted July 27, 2008 If it's an integer column the second one should be fine. Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted July 27, 2008 Share Posted July 27, 2008 Have you tried them? That'll give you the answer really quickly 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.