Up PLEASE ! Realy need help
Please try this sql:
<?php
$sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_content AS com_excerpt
FROM $wpdb->comments
LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
WHERE comment_approved = ’1′ AND comment_type = ” AND post_password = ”
ORDER BY comment_date_gmt DESC
LIMIT 1”;
$comments = $wpdb->get_results($sql);
?>
Hi, do not work get “Parse error: syntax error, unexpected T_STRING” in first line (i am a dunky on php mysql 🙁
try this again. I get the result form this code.
<?php
$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_content AS com_excerpt
FROM $wpdb->comments
LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
WHERE comment_approved = '1' AND comment_type = '' AND post_password = ''
ORDER BY comment_date_gmt DESC
LIMIT 1";
$comments = $wpdb->get_results($sql);
?>
