function CheckImageMaxSize($photosize) { global $db; $sql1="SELECT Resolution,Multiplier FROM `PhotoSizePrice` WHERE Resolution > $photosize ORDER BY Resolution Asc LIMIT 1"; $sql2="SELECT Resolution,Multiplier FROM `PhotoSizePrice` WHERE Resolution < $photosize ORDER BY Resolution Desc Limit 1"; $HigherResult=$db->query($sql1); $LowerResult=$db->query($sql2); if(!$HigherResult OR !$LowerResult) { error_page(); } $higherArr=$HigherResult->fetch_row(); $lowerArr=$LowerResult->fetch_row(); $high=abs($higherArr[0]-$photosize); $low=$photosize-$lowerArr[0]; if ($high < $low) { return ($higherArr[1]); } else { return ($lowerArr[1]); } }