I am trying to wrap my head around the best way to write a query for the following circumstances I know it should be easy but i get very confused when it comes to less then and greater thens. I have 1 table that contains the following columns rank_id, rank_title, rank_min, rank_image I have a variable $postCount I need a query that will take my post count, and compare it to the returned results and pull the correct row of which the postCount falls into. rank_min is the ranks post count minium. example rank 1 = 10 posts rank 2 = 20 posts rank 3 = 30 posts if my user has 22 posts, the query should return rank 2. if my user has 31 posts it should return rank 3. so far i have $database->setQuery("SELECT * FROM fb_ranks WHERE rank_min >= '$postCount'");