21,886
社区成员
发帖
与我相关
我的任务
分享
member
name sh yz id
a111108 7 12 8
a111109 8 0 9
a111110 9 5 10
a111111 10 0 11
a111112 11 18 22
a111113 22 9 23
a111114 23 15 24
a111115 24 12 25
a111116 25 5 26
a111117 26 0 27
a111118 27 9 28
a111119 28 5 29
a111120 29 5 30
a111121 30 0 31
a111122 31 0 32
……
$name="a111120";
$arr = array();
$sql = "select * from aoma_test where name = '$name'";
$res =mysql_query($sql);
$info=mysql_fetch_array($res);
function get_data($info,$arr){
$sql = "select * from aoma_test where id = {$info['sh']}";
$res =mysql_query($sql);
$info=mysql_fetch_array($res);
if($info){
if(!isset($arr[$info['yz']]) && $info['yz']!=0){
$arr[$info['yz']] = $info;
if($info['yz']==18) return $arr;
}
return get_data($info,$arr);
}else{
return $arr;
}
}
$arr = get_data($info,$arr);
$pre_k = 0;
foreach ($arr as $k => $v) {
echo $v['name'].' '.$k.' '.($k-$pre_k).'<br>';
$pre_k = $k;
}