Как-то так
PHP код:
SELECT min_score FROM (SELECT * FROM bd_name WHERE might < значение_силы ORDER BY might < значение_силы, might DESC LIMIT 1) as buff
В виде кода это будет так:
PHP код:
new might = 65000,
min_score;
format(query_string, sizeof(query_string), "SELECT min_score FROM (SELECT * FROM bd_name WHERE might < %d ORDER BY might < %d, might DESC LIMIT 1) as buff", might, might);
new Cache:result = mysql_query(mysql_connection_ID, query_string, true);
cache_get_value_name_int(0, "min_score", min_score);
cache_delete(result);