[RESOLVED] Select first day of month issue..

[joey3002]

Im trying to display some monthly stats. I just want to display the stats for the first day of every month I have in the table.

Thanks

$query = 'SELECT * from stats where DATE_FORMAT('2004-01-20' ,'%Y-%m-01') AS date ORDER BY date DESC LIMIT 30';

$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
$postdate = $row[0];
$number = $row[1];
$ppnumber = $row[2];
$ccnumber = $row[3];

echo"$postdate - $number - $ppnumber - $ccnumber<BR>";
		} 

[joey3002]

$query2 = "SELECT * FROM stats WHERE date LIKE '%-01 00:00:00' ORDER BY date DESC LIMIT 30";