I’m trying to figure and can’t seem to find a way to do it,
this involves Mysql and php.
I need to find a row in a table that column b(see example)
that is greater than or equal to a variable, but i only need just one row, the closest matching one
varA represents COL A and varB represent varB
varA = 1
varB = 55,
I would need row 4, and the the number of rows between varA and what varB gives me, so 3.
Col A - Col B
1 - 5
2 - 10
3 - 20
4 - 50
5 - 100
etc…
any help?