$ Customer_rank_data [& #039; customerrank_minpoints & #039;] array (& #039; GT & #039;, 300); $ customer_rank_data [& #039; customerrank_maxpoints & #039;] array (& #039; LT & #039;, 300 ); why can't I find a piece of data? When the point is 300, the value is equal to or greater than the minimum value...
$ Customer_rank_data ['mermerrank _ minpoints '] = array ('gt', 300 );
$ Customer_rank_data ['mermerrank _ maxpoints '] = array ('lt', 300 );
Why can't I find a piece of data?
That is, when the integral value is 300, the value greater than or equal to the minimum value is smaller than the maximum value. However, the queried value is NULL.
Reply content:
$ Customer_rank_data ['mermerrank _ minpoints '] = array ('gt', 300 );
$ Customer_rank_data ['mermerrank _ maxpoints '] = array ('lt', 300 );
Why can't I find a piece of data?
That is, when the integral value is 300, the value greater than or equal to the minimum value is smaller than the maximum value. However, the queried value is NULL.
My side of the test said no problem, DEMO: http://sqlfiddle.com /#! 2/049288/3/0
The upstairs is correct. min should be <=. Is there a problem with the landlord's SQL?