21,886
社区成员
发帖
与我相关
我的任务
分享
$mid="1025";
$arrj = array();
$sql = "select * from member where id = '$mid'";
$res =mysql_query($sql);
$info=mysql_fetch_array($res);
function get_data($info,$arrj){
$sql = "select * from member where id = {$info['quyu']}";
$res =mysql_query($sql);
$info=mysql_fetch_array($res);
if($info){
if(!isset($arrj[$info['yzchej']]) && $info['yzchej']!=0){
$arrj[$info['yzchej']] = $info;
if($info['yzchej']==15) return $arrj;
}
return get_data($info,$arrj);
}else{
return $arrj;
}
}
$arrj = get_data($info,$arrj);
$pre_k = 0;
foreach ($arrj as $k => $vv) {
$k2=$k-$pre_k;
mysql_query("insert into shouruzc2 (srzc_id,srbeizhu,hktime) values ('$vv[id]','$k2 - $k','$ntime')");
$pre_k = $k;
}
CREATE TABLE IF NOT EXISTS `member` (
`quyu` int(12) DEFAULT '0' COMMENT '接点',
`yzchej` int(2) NOT NULL DEFAULT '0' COMMENT '级差',
`id` int(12) NOT NULL AUTO_INCREMENT COMMENT 'ID号',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1032 ;
INSERT INTO `member` (`quyu`, `yzchej`, `id`) VALUES
(1000, 15, 1001),
(1001, 12, 1002),
(1001, 0, 1003),
(1001, 5, 1004),
(1004, 0, 1005),
(1004, 0, 1006),
(1001, 0, 1007),
(1001, 0, 1008),
(1004, 0, 1009),
(1004, 9, 1010),
(1004, 0, 1011),
(1006, 0, 1012),
(1002, 0, 1013),
(1002, 0, 1014),
(1006, 0, 1015),
(1001, 0, 1016),
(1016, 0, 1017),
(1006, 6, 1018),
(1016, 0, 1019),
(1016, 0, 1020),
(1006, 0, 1021),
(1006, 0, 1022),
(1006, 0, 1023),
(1016, 0, 1024),
(1020, 3, 1025),
(1017, 0, 1026),
(1020, 0, 1027);