PHP sorting question this post was last edited by u010801782 from 2013-07-3023: 32: 15 & lt ;? Phpfunction & nbsp; switchWeek ($ num) {& nbsp; switch & nbsp; ($ num) & nbsp; {& n PHP sorting questions
This post was last edited by u010801782 at 23:32:15
Function switchWeek ($ num ){
Switch ($ num ){
Case 1:
Return 'Monday ';
Break;
Case 2:
Return 'Tuesday ';
Break;
Case 3:
Return 'weday ';
Break;
Case 4:
Return 'Thursday ';
Break;
Case 5:
Return 'Friday ';
Break;
Case 6:
Return 'Saturday ';
Break;
Case 7:
Return 'Sunday ';
Break;
Default:
Return '';
Break;
}
}
$ Con = mysql_connect ("localhost", "root", "") or die ('connection failed: '. mysql_error ());
Mysql_select_db ("testt ");
Mysql_query ('set names utf8 ');
$ SQL = 'select * from news ';
$ Result = mysql_query ($ SQL );
$ Array = array ();
While ($ row = mysql_fetch_array ($ result, MYSQL_ASSOC )){
$ Key = date ('y, m, dday', $ row ['stime']). ''. switchWeek (date ('N', $ row ['stime']);
$ Array [$ key] [] = $ row;
}
Mysql_free_result ($ result );
// Var_dump ($ array );
?>