WHERE <列名> = (SELECT MAX(<列名>) FROM <表名>); } else { $sql = sprintf("select * from whatnew where NO = %d and VALID_STATUS = 1", $current_no); } $con = mysql_logon(); $rtn = mysql_query($sql, $con); $whatnew_data = ""; $arr = mysql_fetch_array($rtn); if ($select_normal==2){ //最後 $current_no=$arr["NO"]; } $title = htmlspecialchars($arr["TITLE"], ENT_QUOTES); $comment = $arr["COMMENT"]; $photo_ps = $arr["PHOTO_POSITION"]; $update_date = htmlspecialchars($arr["UPDATE_DATE"], ENT_QUOTES); $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data.sprintf("

%s

\r\n", $title); $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; if($photo_ps == 3) { if(0 < strlen($arr["PHOTO_FILE_NAME1"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME1"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } if(0 < strlen($arr["PHOTO_FILE_NAME2"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME2"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } if(0 < strlen($arr["PHOTO_FILE_NAME3"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME3"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } } $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; if($photo_ps == 1) { $whatnew_data = $whatnew_data."
\r\n"; if(0 < strlen($arr["PHOTO_FILE_NAME1"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME1"])); } if(0 < strlen($arr["PHOTO_FILE_NAME2"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME2"])); } if(0 < strlen($arr["PHOTO_FILE_NAME3"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME3"])); } $whatnew_data = $whatnew_data."
\r\n"; } $whatnew_data = $whatnew_data.sprintf("
%s
\r\n", nl2br($comment)); if($photo_ps == 2) { $whatnew_data = $whatnew_data."
\r\n"; if(0 < strlen($arr["PHOTO_FILE_NAME1"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME1"])); } if(0 < strlen($arr["PHOTO_FILE_NAME2"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME2"])); } if(0 < strlen($arr["PHOTO_FILE_NAME3"])) { $whatnew_data = $whatnew_data.sprintf("\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME3"])); } $whatnew_data = $whatnew_data."
\r\n"; } $whatnew_data = $whatnew_data.sprintf("
%s
\r\n", makeUpdateDateString($update_date)); $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; if($photo_ps == 4) { if(0 < strlen($arr["PHOTO_FILE_NAME1"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME1"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } if(0 < strlen($arr["PHOTO_FILE_NAME2"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME2"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } if(0 < strlen($arr["PHOTO_FILE_NAME3"])) { $whatnew_data = $whatnew_data.sprintf("
\r\n", makePhotoFileURL($current_no, $arr["PHOTO_FILE_NAME3"])); } else { $whatnew_data = $whatnew_data."
\r\n"; } } $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; $whatnew_data = $whatnew_data."
 
\r\n"; $whatnew_data = $whatnew_data."
\r\n"; mysql_close($con); $contents = str_replace("", $whatnew_data, $contents); print $contents; //-------------------------------------------------------------------- //更新日付文字列の作成 //-------------------------------------------------------------------- function makeUpdateDateString($update_date) { return sprintf("更新日付:%s", $update_date); } //-------------------------------------------------------------------- //写真ファイルのサムネイルURLを作成する処理 //-------------------------------------------------------------------- function makePhotoFileURL($no, $photo) { $makeURL = UPLOAD_URL_WHATNEW.$no."/".$photo; $parts = pathinfo($makeURL); $makeURL = $parts['dirname']."/".$parts['filename']."_s.".$parts['extension']; return $makeURL; } ?>