$sql ="SELECT TIME_To_SEC( NOW( ) ) - TIME_TO_SEC( time_at ) FROM lwjcount WHERE ip = '$ip' ORDER BY 'TIME_To_SEC( NOW( ) )*2 - TIME_To_SEC( time_at )' ASC";
这句隔天就会出现负数
$sql = "SELECT abs( TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at ) ) FROM lwjcount WHERE ip = '$ip' ORDER BY `abs( TIME_TO_SEC( NOW( ) ) - TIME_TO_SEC( time_at ) )` ASC ";
这句正常,害的我找了很长时间