题目本身与数据库无关!
有通用的算法
<?php
//$n人在$t1到$t2期间论排
function foo($n, $t1, $t2) {
if(! is_numeric($t1)) $t1 = strtotime($t1);
if(! is_numeric($t2)) $t2 = strtotime($t2);
$t1 = min($t1, $t2);
$t2 = max($t1, $t2);
$k = 1;
for($i=$t1; $i<$t2; $i+=24*60*60) {
echo date('Y-m-d ', $i).$k.'<br>';
$k = ($k%$n)+1;
}
}
foo(35, '2006-3-1', '2006-5-31');
?>
有通用的算法
<?php
//$n人在$t1到$t2期间论排
function foo($n, $t1, $t2) {
if(! is_numeric($t1)) $t1 = strtotime($t1);
if(! is_numeric($t2)) $t2 = strtotime($t2);
$t1 = min($t1, $t2);
$t2 = max($t1, $t2);
$k = 1;
for($i=$t1; $i<$t2; $i+=24*60*60) {
echo date('Y-m-d ', $i).$k.'<br>';
$k = ($k%$n)+1;
}
}
foo(35, '2006-3-1', '2006-5-31');
?>
while($row = mysql_fetch_array($rs)) {
$ar[] = $row['name'];
}
foo($ar, '2006-3-1', '2006-5-31');function foo($ar, $t1, $t2) {
if(! is_numeric($t1)) $t1 = strtotime($t1);
if(! is_numeric($t2)) $t2 = strtotime($t2);
$t1 = min($t1, $t2);
$t2 = max($t1, $t2);
$n = count($ar);
$k = 0;
for($i=$t1; $i<$t2; $i+=24*60*60) {
echo date('Y-m-d ', $i).$ar[$k].'<br>';
$k = ($k+1) % $n;
}
}