Yea, I just figured this out. When I cut and pasted I must have overwrote the =. Thanks > -----Original Message----- > From: Stut [mailto:stuttle@xxxxxxxxx] > Sent: January 4, 2007 4:27 PM > To: Beauford > Cc: PHP > Subject: Re: Date problems > > Beauford wrote: > > $query "select count(date) as count, YEAR(date) as thisyear > from stats > > group > ^ = needed here > > by thisyear"; > > -Stut > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php