Sanırım böyle birşey arıyorsun

$sql = mysql_query ("SELECT * FROM kategori ORDER BY katadi ASC LIMIT 30"); 
while($goster[]=mysql_fetch_array($sql)) {}
$i=0;
foreach ($goster as $k=> $v ){
echo($i%10==0)?'<table width="100" border="0">':'';
echo '<tr>
    <td>'.$v['id'].'</td>
    <td>'.$v['katadi'].'</td>
    <td>&nbsp;</td>
  </tr>';
echo($i%10==9 || ($i == count($data)-1 ))?'</table>':'';
$i++;
}