Featured Items

I am trying to create a set of featured items at the top of the results pages (like HotScripts.com) where their background and border are a different color, and they are the first to come up in the results. Now, the ordering I can do in a SQL statement using a column in the table called 'ranking':

SELECT * FROM table WHERE row_id = 123 ORDER BY ranking DESC

What I need now, is a way to manipulate each row to show the correct designation. For example, if I get a ranking 7 through 10, I want the result row to change to a red border and a light pink background. Conversly, if the ranking is below 7 then the color would be a gray background with a black border.

Is this possible?

Thanks!
Sean