onedumbcoder Posted September 12, 2009 Share Posted September 12, 2009 No idea what is wrong with it, but I am trying to get the top scores for "SELECT number_of_kills FROM kill WHERE type == 'jews' OR type ='arabirans' AND method='chamber' ORDER BY number_of_kills LIMIT 10 it is not returning the correct data, what it is suppose to do is return the top players for the chamber kills, and instead is returning scores that make no sense. Quote Link to comment Share on other sites More sharing options...
grissom Posted September 12, 2009 Share Posted September 12, 2009 A couple of thoughts 1. Try a single equals sign in type = 'jews' 2. Put some brackets around your AND and OR statements to explicitly define exactly what you mean Quote Link to comment Share on other sites More sharing options...
fenway Posted September 12, 2009 Share Posted September 12, 2009 That's a mighty racist database you're working on. 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.