[SOLVED] Select Row with number closest to and higher than x

[alconebay]

I need a query to select a row that contains the number that is closest to (and also higher than) a particular number.

 

So say my number is 5 and my table has rows with 1, 4, 7, and 12 in it. I would need the query to select the row that has 7 in it.

 

SELECT * FROM schedule WHERE ??

[gevans]

OK, so lets say the field in your table `schedule` was `numbers`

 

`numbers` contains 1, 4, 7 and 12 as you said

 

$comp = 5;//your comparison
$query = "SELECT * FROM `schedule`
WHERE `numbers` > $comp
ORDER BY `numbrs` ASC
LIMIT 1";

[alconebay]

Thanks!