TEENFRONT Posted January 22, 2009 Share Posted January 22, 2009 Hey im using the > sign to do some selecting in mysql... is there a way to do WHERE x > y but "within" 50 either side? im using it to select websites to share traffic with and its WHERE hits_in > hits_out so sites who i owe traffic do are sent traffic..but id like to add a buffer of 50 to it if that makes sense...is this possible or should i do it another way? Quote Link to comment https://forums.phpfreaks.com/topic/141978-using-greater-than-but-adding-a-limit/ Share on other sites More sharing options...
TEENFRONT Posted January 23, 2009 Author Share Posted January 23, 2009 im still struggling with this.. id like to uses the greater than value....but within 50 either side.. Quote Link to comment https://forums.phpfreaks.com/topic/141978-using-greater-than-but-adding-a-limit/#findComment-744109 Share on other sites More sharing options...
Mchl Posted January 23, 2009 Share Posted January 23, 2009 Don't know if I understand you correctly. Perhas you're after this: WHERE x > y AND x < 50 AND y < 50 If not, please explain in more detail. Quote Link to comment https://forums.phpfreaks.com/topic/141978-using-greater-than-but-adding-a-limit/#findComment-744113 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.