Problema con consulta

[carlosgs91]

¿Qué hago mal?

$howmanydates = mysql_db_query("$mysql_database", "SELECT * FROM Media WHERE Type = 'Audio' and Date >= '$yearnow-$j-1' and Date < '$yearnow-$j2-1'");

$countposts = mysql_num_rows($howmanydates);

Eso falla, (aunque desde el phpmyadmin no), pero esta consulta funciona:

$howmanydates = mysql_db_query("$mysql_database", "SELECT * FROM `$rowm[Ref]` WHERE `Date` >= '$yearnow-$j-1' and `Date` < '$yearnow-$j2-1'");

$countposts = mysql_num_rows($howmanydates);