从最后一个查询中获取行数 - get number of rows from last query, Wordpress

get number of rows from last query, Wordpress

本文关键字：获取最后一个查询 | 更新日期: 2023-09-27

我在一个wordpress平台上工作，同时生成一个mysql查询，我想显示从该查询的行数。示例如下:

$query = ("SELECT wp_posts.ID, wp_term_relationships.object_id
     FROM wp_posts
     LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
     WHERE post_date <= '$now'
     AND term_taxonomy_id = '$catid'
     AND post_date >= '$then' 
     AND post_status = 'publish'");

现在，当我在phpmyadmin中生成这个查询时，它会给出以下输出显示第0 - 5行(总共6行，查询用时0.0013秒)

我想显示行数I -e 6总计…那么我必须用什么函数来显示它??

$query = ("SELECT count(*), wp_posts.ID, wp_term_relationships.object_id
 FROM wp_posts
 LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
 WHERE post_date <= '$now'
 AND term_taxonomy_id = '$catid'
 AND post_date >= '$then' 
 AND post_status = 'publish'");