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. Link to comment https://forums.phpfreaks.com/topic/174026-not-sure-why-this-query-is-not-working-correctly-please-help/ 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 Link to comment https://forums.phpfreaks.com/topic/174026-not-sure-why-this-query-is-not-working-correctly-please-help/#findComment-917351 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. Link to comment https://forums.phpfreaks.com/topic/174026-not-sure-why-this-query-is-not-working-correctly-please-help/#findComment-917359 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.