21,893
社区成员




//给你写一个吧
$sql="select distinct date from table oder by date ";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)({
$sql1="select * from table where date=".$row['date'] order by time;
$result1=mysql_query($sql1);
$i=0
while($row1=mysql_fetch_array($result1)){
$i++;
if($i=1){
$sql2="insert into table2 (date,time1,time2,time3,time4,time5) values ('".$row['date']."','"$row1['time']."','0','0','0','0')"; //日期型是否加隐号不知道
}else{
$sql2="update table2 set time".$i." =".$row1['time']." where date='".$row['date']."'";
}
mysql_query($sql2);
}
}