本帖最后由 u010801782 于 2013-07-30 23:32:15 编辑
<br>
<?php <br />
function switchWeek($num){<br>
switch ($num) {<br>
case 1:<br>
return '星期一';<br>
break;<br>
case 2:<br>
return '星期二';<br>
break;<br>
case 3:<br>
return '星期三';<br>
break;<br>
case 4:<br>
return '星期四';<br>
break;<br>
case 5:<br>
return '星期五';<br>
break;<br>
case 6:<br>
return '星期六';<br>
break;<br>
case 7:<br>
return '星期日';<br>
break;<br>
default:<br>
return '';<br>
break;<br>
}<br>
}<br>
$con = mysql_connect("localhost","root","") or die('连接失败:'.mysql_error());<br>
mysql_select_db("testt");<br>
mysql_query('set names utf8');<br>
$sql = 'select * from news ';<br>
$result = mysql_query($sql);<br>
$array = array();<br>
while($row = mysql_fetch_array($result,MYSQL_ASSOC)){<br>
$key = date('Y年m月d日',$row['sTime']).' '.switchWeek(date('N',$row['sTime']));<br>
$array[$key][]=$row;<br>
}<br>
mysql_free_result($result);<br>
//var_dump($array);<br>
?><br>
nbsp;html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br>
<div class="clear">
</div>
