$search_res=$db->query($search_sql);
for($m=0;$m<$n;$m++) {
$search_result=$db->fetch_row($search_res);
$start_date1=$search_result[3];
$end_date1=$search_result[4];
$time1 = strtotime ($start_date1);
$time2 = strtotime ($end_date1);
$time = ($time2-$time1)/86400;
}
这个是在for循环里面,$time取出来以后是N条记录i,我怎么把他们相加起来,求出一个总和?
for($m=0;$m<$n;$m++) {
$search_result=$db->fetch_row($search_res);
$start_date1=$search_result[3];
$end_date1=$search_result[4];
$time1 = strtotime ($start_date1);
$time2 = strtotime ($end_date1);
$time += ($time2-$time1)/86400;
}是这个意思么
for($m = 0;$m < $n;$m ++) {
$search_result = $db->fetch_row($search_res);
$start_date1 = $search_result[3];
$end_date1 = $search_result[4];
$time1 = strtotime ($start_date1);
$time2 = strtotime ($end_date1);
$time += ($time2-$time1)/86400;//这里就是你取出的$time相加。
}
我勒个去,你输出什么?time+?
$time += ($time2-$time1)/86400;的含义是什么?$time = $time + ($time2-$time1)/86400;
$sql = "select ...........";//查询的sql语句
$res = mysql_query($sql);
while($result = mysql_fetch_array($res)) {
$start_date1 = $result['startdate'];//startdate换成你的字段
$end_date1 = $result['enddate'];//enddate换成你的字段
$time1 = strtotime ($start_date1);
$time2 = strtotime ($end_date1);
$time +=($time2-$time1)/86400;
}
echo $time;