datarow2colom

# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jun 16, 2008 at 08:58 AM
# Server version: 5.0.26
# PHP Version: 5.1.6
#
# Database : `test1`
#

# --------------------------------------------------------

#
# Table structure for table `testproduk`
#

CREATE TABLE `testproduk` (
`pid` varchar(255) NOT NULL,
`item` varchar(255) NOT NULL,
`desc` varchar(255) NOT NULL,
`price` varchar(255) NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `testproduk`
#

INSERT INTO `testproduk` (`pid`, `item`, `desc`, `price`) VALUES ('p001', 'item1', 'desc1', '1'),
('p002', 'item2', 'desc2', '2'),
('p003', 'item3', 'desc3', '3'),
('p004', 'item4', 'desc4', '4'),
('p005', 'item5', 'desc5', '5'),
('p006', 'item6', 'desc6', '1'),
('p007', 'item7', 'desc7', '2'),
('p008', 'item8', 'desc8', '3'),
('p009', 'item9', 'desc9', '4'),
('p010', 'item10', 'desc10', '5'),
('p011', 'item11', 'desc11', '1'),
('p012', 'item12', 'desc12', '2'),
('p013', 'item13', 'desc13', '3'),
('p014', 'item14', 'desc14', '4'),
('p015', 'item15', 'desc15', '5'),
('p016', 'item16', 'desc16', '1'),
('p017', 'item17', 'desc17', '2'),
('p018', 'item18', 'desc18', '3'),
('p019', 'item19', 'desc19', '4'),
('p020', 'item20', 'desc20', '5'),
('p021', 'item21', 'desc21', '1'),
('p022', 'item22', 'desc22', '2'),
('p023', 'item23', 'desc23', '3'),
('p024', 'item24', 'desc24', '4'),
('p025', 'item25', 'desc25', '5'),
('p026', 'item26', 'desc26', '1'),
('p027', 'item27', 'desc27', '2'),
('p028', 'item28', 'desc28', '3'),
('p029', 'item29', 'desc29', '4'),
('p030', 'item30', 'desc30', '5');

<?php
$myconn=mysql_connect("localhost","root","root");
mysql_select_db("test1");

$sql = 'SELECT `pid` , `item` , `desc` , `price` '
. ' FROM `testproduk` LIMIT 0, 30';
$rs = mysql_query($sql);

$slice = 3;
$doslice= true;
$part = ceil(mysql_num_rows($rs)/$slice);
$width = floor(100/$slice)."%";
?>
<style type="text/css">
<!--
.trheader {
background-color: #00BBF9;
font-weight:bold;
color:#333333;
}
.trdata {
background-color: #EAEAEA;
}
-->
</style>
<strong>PRICE LIST</strong>
<table width="100%" border="0" cellspacing="0" cellpadding="3" style="border:2px solid #cfcfcf;font:8pt tahoma;">
<tr>
<td width="<?=$width;?>" valign="top" align="center">
<?php
$i=0;
$lo=0;
while($row=mysql_fetch_array($rs)){$i++;$lo++;
if($lo==1){
?>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" style="border:1px solid #cfcfcf;font:8pt tahoma;">
<tr class="trheader">
<td width="20">No</td>
<td>Pid</td>
<td>Desc</td>
<td>Price</td>
</tr>
<?php
}
?>
<tr class="trdata">
<td><strong><?=$i;?>.</strong></td>
<td><?=$row['pid'];?></td>
<td><?=$row['desc'];?></td>
<td><?=$row['price'];?></td>
</tr>
<?php if($lo==$part&&$doslice==true){
echo '</table>';
echo '</td>';
echo '<td width="'.$width.'" valign="top" align="center">';
$lo=0;
}
?>
<?php
}
?>
</table>
</td>
</tr>
</table>
<br />
<br />
<table width="300" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#F4F4F4" style="border:2px solid #cfcfcf;font:8pt tahoma;color:#333333;">
<tr>
<td style="text-align:justify;"><strong><u>Triks Data Row 2 Columns or more</u></strong><br />
good for print price list in 2 or more column <br />
<br />
bagus digunakan untuk memprint price list yang membutuhkan beberapa kolom dalam menampilkan data yang sama, kelebihannya adalah anda hanya perlu menjalankan query 1 kali saja untuk menampilkan data harga dari database. <br />
jika anda menggunakan applikasi web developer dengan WISYWIG akan mudah sekali dalam merubah dan atau menambahkan colom baru. <br />
Trik ini tentu bisa juga digunakan untuk menampilkan tabel lain. <br />
<br />
Selamat Mencoba<br />
<br />
<div style="font-family:Georgia;font-style:italic;font-weight:bold;text-align:right;"><a href="mailto:bageer83@yahoo.co.id?subject=Triks Data Row 2 Columns" style="

bg83