I have a database which stores listings in 2 main categories.
I am trying to select the total number of listings in each of the categories with
term_taxonomy_id's of 109 and 110 that have been added within the last 3 days.
This is what I have so far, but it’s not showing anything when echoing. I also don’t know how to select them based on a time period of 3 days
$total_competitions = mysql_query("SELECT COUNT(term_taxonomy_id=109) FROM wp_term_taxonomy;"); echo $total_competitions;
Could anyone help me with the query?
This is a screenshot of the table in phpmyadmin: