Posted by Wayne Delia on 06/21/05 00:06

Bryan wrote:
> I've been trying to work out a problem but I'm having no luck. I have
> field in my table for area and I need to count the number of matches
> and assign a variable for each one.. this is what I have but it doesn't
> work.. any ideas?
>
> $testcount = mysql_query("select area, count(area) as newcount from rea
> group by area order by area");

MySql queries involving count(columname) require a GROUP BY clause, for
starters.

WMD

[Back to original message]