[How to] Add New Tags or Taxonomies to WordPress using PHP

WPAssist // January 2, 2019

function wpassist_insert_terms(){ $ahc = get_term_by('name', 'American Heroes Channel', 'post_tag'); if( !$ahc ){ wp_insert_term( 'American Heroes […]

MySQL Query to Get a Random Post from WordPress Database

WPAssist // January 1, 2019

SELECT DISTINCT p.ID, p.post_title FROM wp_posts p WHERE p.post_type = 'post' AND p.post_status = 'publish' […]

SQL Query to Get Posts Using Category Name

WPAssist // December 26, 2018

select p.id, p.post_title from wp_posts p inner join wp_term_relationships tr on tr.object_id = p.ID inner […]

[How to] Display Number of Posts in WordPress

WPAssist // December 26, 2018

Using WordPress core function wp_count_posts, you can easily display total number of posts. Here is […]

MySQL Query to List WordPress Posts Using Meta Query

WPAssist // December 26, 2018

To get a list of WordPress Posts using meta query in MySQL, you can use […]