Wordpress PHP get_results unexpected T_STRING

Question

在尝试使用我创建的这个函数时，我收到了一个意外的t_string。我知道我一定错过了什么。

function get_top_terms(){
global $wpdb;
$termsSQL = "SELECT DISTINCT AN_terms.name from AN_posts INNER JOIN AN_term_relationships on AN_term_relationships.object_id = AN_posts.ID INNER JOIN AN_term_taxonomy on AN_term_taxonomy.term_taxonomy_id=AN_term_relationships.term_taxonomy_id INNER JOIN AN_terms on AN_term_taxonomy.term_id=AN_terms.term_id where AN_posts.post_date_gmt >= NOW() - INTERVAL 1 DAY and AN_term_taxonomy.taxonomy = "post_tag" group by AN_terms.name order by count DESC limit 5";
$tResults = $wpdb->get_results($termsSQL);
print_r($tResults);
}
add_shortcode ( 'topTerms', 'get_top_terms');

Answer 1

试试这个

function get_top_terms(){
global $wpdb;
$termsSQL = "SELECT DISTINCT AN_terms.name from AN_posts INNER JOIN AN_term_relationships on AN_term_relationships.object_id = AN_posts.ID INNER JOIN AN_term_taxonomy on AN_term_taxonomy.term_taxonomy_id=AN_term_relationships.term_taxonomy_id INNER JOIN AN_terms on AN_term_taxonomy.term_id=AN_terms.term_id where AN_posts.post_date_gmt >= NOW() - INTERVAL 1 DAY and AN_term_taxonomy.taxonomy ='post_tag' group by AN_terms.name order by count DESC limit 5";
$tResults = $wpdb->get_results($termsSQL);
print_r($tResults);
}
add_shortcode ( 'topTerms', 'get_top_terms');

出现一个简单的语法错误。

我刚刚更改了"post_tag"部分