First I apologize for the long code I can't be bothered at this point to mess with the code it's already frustrating me enough (i am human do get angry..)
What I am trying to do is display the latest comments in the database I have tried DESC this displays comments from top to below which is alright but not what I need I also tried ASC and that's not displaying the most recent comments as I have a LIMIT.
I need it to work exactly how the facebook comment system works if that makes more sense but nothing is working :/
If this doesn't make sense let me know hope it does
Here's the code
$select_comments2 = $db->query("
SELECT * FROM " . TABLE_PREFIX . "groups_comments WHERE post_id='$escape_post_id_row' AND post_id='$_GET[pid]' ORDER BY comment_id DESC LIMIT 10");