If ID is found in query

[dachshund]

Hi,

 

I have a query which selects posts that are trending (ie. have had more than 600 views after 2 hours of being live), but now I want to be able to add a little label to the trending posts that says "trending" if the ID is included in this query. Hopefully that makes sense. This is the query I have:

 

 

 
$sql = "SELECT *, views / HOUR(TIMEDIFF(NOW(), date)) as avg
    FROM content
     WHERE date BETWEEN CURDATE() - INTERVAL 30 DAY AND NOW() - INTERVAL 2 HOUR
     AND views > 600 
     AND live = '0'
     ORDER BY avg DESC
     LIMIT 8";
 

[QuickOldCar]

Not enough of your code to tell exact.

 

You do that within your loop.

 

while($row=...................){

 

if($row('id') == $post_id){

  echo "trending";

  //$trending = true;

}

 

}