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");
while ($returncount = mysql_fetch_array($testcount)) {
if ($returncount[area] == 'RCC') {
$rccn = $returncount[newcount];
}
if ($returncount[area] == 'RCL') {
$rccl = $returncount[newcount];
}
if ($returncount[area] == 'RCH') {
$rcch = $returncount[newcount];
}
if ($returncount[area] == 'RCW') {
$rccw = $returncount[newcount];
}
if ($returncount[area] == 'RNK') {
$rnkn = $returncount[newcount];
}
if ($returncount[area] == 'RNK') {
$rnen = $returncount[newcount];
}
}