Skip to content

Instantly share code, notes, and snippets.

@rafsuntaskin

rafsuntaskin/last_comment_on_post.php

Created June 18, 2015 05:34
Show Gist options
  • Save rafsuntaskin/7fadc022a018317ff427 to your computer and use it in GitHub Desktop.
Save rafsuntaskin/7fadc022a018317ff427 to your computer and use it in GitHub Desktop.
Download ZIP
Get last comment for a wordpress post
Raw
last_comment_on_post.php
$PostID = 215;
global $wpdb;
$p = $wpdb->prefix;
var_dump($wpdb->get_results($wpdb->prepare("SELECT comment_date FROM {$wpdb->prefix}comments WHERE comment_post_ID = %d ORDER BY comment_date DESC LIMIT 1",$PostID)));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment