'yes' and `display` = 'yes' and `cup` <> 'A' and `cup` <> 'B' and `cup` <> 'C' and `cup` <> 'D' and `cup` <> '' order by bust desc "; }elseif($_GET["sh"] == "mikeiken"){ $sql = " SELECT * from {$tblname} where `delete` <> 'yes' and `display` = 'yes' and `mikeiken` = 'yes' order by list desc "; }else{ $sql = " SELECT * from {$tblname} where `delete` <> 'yes' and `display` = 'yes' order by list desc "; } $res = mysql_query( $sql ); while( $row = mysql_fetch_array( $res ) ) { //出勤 $attendicon = casat($row["id"]); //pickup if(strlen($row["pickup"]) > 1){ $pickup = " PickUp!"; }else{ $pickup = ""; } //NEW $nowtime = time(); if(strtotime($row["date"]) > $nowtime - 2592000){ $newface = " "; }else{ $newface = ""; } ?>