$query_Recordset1 = "select org_name, sum(IF(dopek=221100, now_summ, NULL)) as c221100, sum(IF(dopek=223102, now_summ, NULL)) as c223102, sum(IF(dopek=226600, now_summ, NULL)) as c226600 FROM (select org_name, dopek,now_summ from kr_reestr ) as x GROUP BY org_name";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $q) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
<table border="1">
<tr>
<td>org_name</td>
<td>c221100</td>
<td>c223102</td>
<td>c226600</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['org_name']; ?></td>
<td><?php echo $row_Recordset1['c221100']; ?></td>
<td><?php echo $row_Recordset1['c223102']; ?></td>
<td><?php echo $row_Recordset1['c226600']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
в таблицу попадает только первая строчка... не пойму почему.... кто нить подскажет?