grouping db records

Anon

any ideas where i am going wrong ? the db has around 1000 records in about 81 area categories

the following does group the records okay but also creates another blank entry for every other record in the db ??? making the file size 1.5mb !! and my little 24mb server run like a snail !!

<?
$resultx = mysql_query("SELECT * FROM ukd GROUP by 'AREA'");
$listx = mysql_num_rows($resultx);
while ($ix < $listx) {
$rowx = mysql_fetch_array($resultx);
$areax = $rowx["AREA"];
print"<tr>";
print"<td>$areax</td>";
print"</tr>";
$i++;
}
?>

would i be easier to set up another table that would just pull out the AREA count etc ? the db could increase easily to 4000+ records

any help once again greatly appreciated, even to add a group field count ?

sepodati

<?
$resultx = mysql_query("SELECT AREA FROM ukd GROUP BY AREA");
while(list($areax) = mysql_fetch_row($resultx))
{
echo "<tr><td>$areax</td></tr>\n";
}
$num_records = mysql_num_rows($resultx)

You only need the last line if you want to print out the number of rows returned for some reason. otherwise you can take it out. Try that code and see if it works...

I think your problem is you're incrementing $i, but using $ix in your while comparison. That means your while loop would never end...

---John Holmes...

Anon

Usually in a GROUP BY your do some aggregate funtion on a column like a count or sum. It looks like here your just trying to pull out distinct values for area. Try this:

SELECT DISTINCT AREA FROM ukd;

and if you don't want null areas:

SELECT DISTINCT area FROM ukd WHERE area IS NOT NULL; (The group and distinct clauses will return nulls, you might need to compensate for spaces also).