1)); $atable->alternate_color(0,'#DCFFFFF'); $atable->new_row(); $atable->new_cell('Variety'); $atable->new_cell('#Problems'); // get first row in query result $thearray = mysql_fetch_array($res); extract ($thearray); $currentflvar_id = $flagvariety_id; $currentflvar = $flagvariety; $flvarcounter = 1; // counts repeats of flag varieties // now extract rest of dbase rows while ($thearray = mysql_fetch_array($res)) { extract ($thearray); while ( ($currentflvar_id == $flagvariety_id) ) { // keep extracting for repeat flag varieties $currentflvar_id = $flagvariety_id; $currentflvar = $flagvariety; if (!($thearray = mysql_fetch_array($res))) break; extract ($thearray); $flvarcounter++; } $atable->new_row(); // create link to this set of flag variety problems $totlink = ''.'Fl('.$currentflvar.')'; $atable->new_cell($totlink); $atable->new_cell($flvarcounter); $flvarcounter = 1; $currentflvar_id = $flagvariety_id; $currentflvar = $flagvariety; } $atable->show_table(); ?>