[RESOLVED] combined row if there condition

[apdentalsystem]

i have mysql table

#
# Table structure for table tb_test_copy
#
CREATE TABLE `tb_test_copy` (
`Newsid` int(11) NOT NULL AUTO_INCREMENT,
`news` varchar(160) DEFAULT NULL,
`Multipart` tinyint(3) DEFAULT NULL,
`MultipartRef` varchar(10) DEFAULT NULL,
`MultipartCount` smallint(6) DEFAULT NULL,
`ThisPart` varchar(10) DEFAULT NULL,
PRIMARY KEY (`Newsid`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
#
# Dumping data for table tb_test_copy
#
INSERT INTO `tb_test_copy` VALUES (28,'action',0,'',0,'0');
INSERT INTO `tb_test_copy` VALUES (29,'drama',0,'',0,'0');
INSERT INTO `tb_test_copy` VALUES (30,'Part 1',1,'A',2,'1');
INSERT INTO `tb_test_copy` VALUES (31,'Part 2',1,'A',0,'2');
INSERT INTO `tb_test_copy` VALUES (33,'song',0,'',0,'0');


i don't know how to explain my problem, but i have picture. i want merge row that have multipartcount and combine with same MultipartRef sort by ThisPart when merge. thanks for forum help

[Ecniv]

stackoverflow to the rescue

[apdentalsystem]

stackoverflow to the rescue

exactly that i want. thanks my friend.sorri for late reply