willy_transpose.pehape

<h2>Coding ane :</h2>
<form method="POST">
<input type="text" name="addtext"><input type="submit" name="addbutton" value="ADD">
</form>
<?php
if(isset($_POST["addbutton"])){
    mysql_query("insert into `table` set `field`='".$_POST["addtext"]."'");
}
?>
<table style="background:#F0F0F0;" border=1 style="border-collapse:collapse" width="20%">
        <tbody align=center>
<?php
$limit=6;
$arr_semua = array();

$query = "select `field` from `table`";
$result = mysql_query($query);
$nrow = mysql_num_rows($result);

$kolom = floor($nrow/$limit);
$sisa = $nrow%$limit;
if($sisa) $kolom++;

while($row = mysql_fetch_array($result)) {
        $arr_semua[] = $row['field'];
}
mysql_free_result($result);

$arr_group = array();
echo "<tr>\n";
for($i=0;$i<$kolom;$i++) {
        $arr_group[$i] = array();
        echo "<td>Col$i</td>\n";
}
echo "</tr>
<tr>\n";

$ok = true;
for($i=0;$i<$kolom && $ok;$i++) {
        for($j=0;$j<$limit;$j++) {
                $k = $i*$limit + $j;
                if($k>=$nrow) {
                        $ok = false;
                        break;
                }
                $arr_group[$i][$j] = $arr_semua[$k];
        }
}

$ok = true;
$cnt = 0;
for($i=0;$i<$limit && $ok;$i++) {
        echo "<tr>\n";
        for($j=0;$j<$kolom;$j++) {
                $cnt++;
                if(isset($arr_group[$j][$i])) {
                        echo "<td>".$arr_group[$j][$i]."</td>\n";
                } else {
                        echo "<td>&nbsp;</td>\n";
                }
        }
        echo "<tr>\n";
}
?>
        </tbody>
</table>