Can someone help me with a MYSQL query? Trying to select muilt. WHERES?

[mazman13]

My query looks like this.

 

$query = "SELECT COUNT(quality) AS twriter FROM data WHERE quality='Y' AND date BETWEEN '$year-$month-00' AND '$year-$month-32' AND writer='Dusty'";

$result = mysql_query($query)or die(mysql_error());

$row = mysql_fetch_assoc($result);

extract($row);

echo"$twriter";

 

It should return with the number 6. But it returns 0. If I delete the Yellow part it brings back 7. Which is correct.

 

What is wrong with the query? Everything is correct. I have 6 rows with the writer Dusty. If I update a row, it will timestamp that row and will show on the query. Could there be something wrong with the dates? It seems to only pull it if it was created on todays date.

 

[trq]

I can't even see the yellow part. We have [ code ][ /code ] tags for a reson.