php - MYSQL - 获取适当的现金返还值

Question

我有 1 个 mysql 表，其中包含以下值。

When pass value as 5, it should return cashback_vaule = 1
because passed value within 1-10 range & its cashback_vaule is 1

和

When pass value as 25, it should return cashback_vaule = 3
because passed value within 21-30 range & its cashback_vaule is = 3

和

When pass value more than 30, it should return cashback_vaule = 3
because max cashback_vaule is = 3

我需要进行查询以相应地获取cashback_vaule。

tbl_cashback

-------------------------------------------------------------
id  cashback_range_from cashback_range_to   cashback_vaule(%)
-------------------------------------------------------------
1   1                   10                   1
2   11                  20                   2
3   21                  30                   3
-------------------------------------------------------------

Answer 1

你可以试试这个

$your_value = "5";

$sql = "SELECT * FROM tbl_cashback 
        WHERE '$your_value'>=cashback_range_from
        AND '$your_value'<=cashback_range_to ";