如何这样布局数据
数据结构如下:
<br> SET FOREIGN_KEY_CHECKS=0;<br> -- ----------------------------<br> -- Table structure for arp_careset<br> -- ----------------------------<br> CREATE TABLE `arp_careset` (<br> `id` int(11) NOT NULL auto_increment,<br> `name` varchar(255) character set utf8 default NULL,<br> `typegroup` varchar(255) character set utf8 default NULL,<br> `remark` varchar(255) character set utf8 default NULL,<br> `deleted` int(11) default NULL,<br> `modified_by` int(11) default NULL,<br> `createtime` datetime default NULL,<br> `created_by` int(11) default NULL,<br> `lastmodifytime` datetime default NULL,<br> PRIMARY KEY (`id`)<br> ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;<br> <br> -- ----------------------------<br> -- Records <br> -- ----------------------------<br> INSERT INTO `arp_careset` VALUES ('1', '体表', 'dissect-position', 'surface', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('2', '淋巴结', 'dissect-position', 'lymph', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('3', '头颈部', 'dissect-position', 'head', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('4', '胸部', 'dissect-position', 'chest', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('5', '腹部', 'dissect-position', 'abdomen', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('6', '营养状况', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00');<br> INSERT INTO `arp_careset` VALUES ('7', '分泌物', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('8', '被毛', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('9', '皮肤', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('10', '眼/眼眶', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('11', '四肢/尾巴', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('12', '乳腺', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('13', '外生殖器', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('14', '肛门', 'position-surface', '', '1', null, '0000-00-00 00:00:00', '0', null);<br> INSERT INTO `arp_careset` VALUES ('15', '腋窝淋巴结', 'position-lymph', '', '1', null, '0000-00-00 00:00:00', '0', null); <div class="clear"> </div>