目前已知新增12筆為下列所示...但不明白的是如何在新增第二筆時開始跟結束月份各+1~第三筆開始跟結束月份各+2...以此類推

$REQUEST_METHOD = $_SERVER['REQUEST_METHOD']; if($REQUEST_METHOD == 'POST'){ $wname = $_POST["w_name"]; $cname = $_POST["r_cname"]; $ename = $_POST["r_ename"]; $page = $_POST["r_page"]; $subject1 = $_POST["r_subject1"]; $subject2 = $_POST["r_subject2"]; $score = $_POST["r_score"]; $impact = $_POST["r_impact"]; $date = $_POST["r_date"]; $range1 = $_POST["r_range1"]; $range2 = $_POST["r_range2"]; $rank = $_POST["r_rank"]; $author1 = $_POST["r_author1"]; $author2 = $_POST["r_author2"]; $method = $_POST["r_method"]; $note = $_POST["r_note"]; /*第1筆*/ $sql_query = mysql_query("INSERT INTO research (w_name, r_cname, r_ename, r_page, r_subject1, r_subject2, r_score, r_impact, r_date, r_range1, r_range2, r_rank, r_author1, r_author2, r_method, r_note) VALUES ('$wname', '$cname', '$ename', '$page', '$subject1', '$subject2', '$score', '$impact', '$date', '$range1', '$range2', '$rank', '$author1', '$author2', '$method', '$note')"); //如果插入的欄位有數字型態的,後面value不能有單引號 /*第2筆*/ $sql_query = mysql_query("INSERT INTO research (w_name, r_cname, r_ename, r_page, r_subject1, r_subject2, r_score, r_impact, r_date, r_range1, r_range2, r_rank, r_author1, r_author2, r_method, r_note) VALUES ('$wname', '$cname', '$ename', '$page', '$subject1', '$subject2', '$score', '$impact', '$date', '$range1', '$range2', '$rank', '$author1', '$author2', '$method', '$note')"); //如果插入的欄位有數字型態的,後面value不能有單引號 /*第3筆*/ $sql_query = mysql_query("INSERT INTO research (w_name, r_cname, r_ename, r_page, r_subject1, r_subject2, r_score, r_impact, r_date, r_range1, r_range2, r_rank, r_author1, r_author2, r_method, r_note) VALUES ('$wname', '$cname', '$ename', '$page', '$subject1', '$subject2', '$score', '$impact', '$date', '$range1', '$range2', '$rank', '$author1', '$author2', '$method', '$note')"); //如果插入的欄位有數字型態的,後面value不能有單引號 /* ......... 貼到12次為12筆 ........ */ if (!sql_query){ die('Could not connect4: ' . mysql_error()); } header("Location:./r_admin.php"); } ?>

幾點設計觀念給你好了。

不知道這樣的方法是你自已想的還是上面的人幫你想的。說真的，其實這樣的做法是非常的差的。反而你之前用的日期區間方式還比較好一點。

會覺得非常差的原因是指，同等資料中分次寫入跟搜尋時資料變大。再者不管如何想，其效能都是會變成非常的惡劣。
如果會員人數少可能還可以應付，會員人數多就會很可怕。

用基本的計算來說，一個案件100個會員購買1年來算。你的資料筆數就至少要先有 1*100*12 = 1200。
而表搜尋效能最大容許量約在8000筆左右。再大其效能就會開始降低。依照這樣的計算，100個會員就多只能容許7個案子。

其次要說明的。我想你的起始日因該也是要當索引搜尋用的值。一般來說會盡量不去用中文字來做欄位比對值。也就是說~~~你的「2011.05月」
其實也可以只要儲存「2011.05」或是「201105」後者為佳。顯示再做個手腳來增加你要的格式就行了。

最後~~多筆寫入可以用如下的方式

由於我不確定你要累加的欄位為何，在此我用一個可能的東西$method來做你的累加值。不對你在自行調整。
$i的值，因為我不知道你要的東西為何，我先假設由0~12的累加
for($i=0;$i<=12;$i++) { $sql_data[] = "('$wname', '$cname', '$ename', '$page', '$subject1', '$subject2', '$score', '$impact', '$date', '$range1', '$range2', '$rank', '$author1', '$author2', '".($method+$i)."', '$note')"; } $sql_Str = "INSERT INTO research (w_name, r_cname, r_ename, r_page, r_subject1, r_subject2, r_score, r_impact, r_date, r_range1, r_range2, r_rank, r_author1, r_author2, r_method, r_note) VALUES ".implode(',',$sql_data); $sql_query = mysql_query($sql_Str);

以上~~~

後記：
原則上我不建議你用這樣的想法來做。未來你一定會發生問題。如果有想要討論做法怎麼樣是最好的。可以詳述你的需求。我可以幫你規劃db的架構及程式上的應用方法給你。

您好，我也明白此種方法為下下策，但至少為方法中的一種

因目前我能寫程式的時間實在不多，加上18號之前要把這個CASE交出，所以上層才想說叫我往這邊去著手

關於上星期問的日期區間查詢，因電腦被換過所以沒留下資料只有半個月前的備份：(

您之前回覆　SQL中假設要查詢2011.07月的可用如下

SELECT 員工代碼,員工名稱,sum(積分) FROM research LEFT JOIN worker USING(員工代碼) where s_date<='201107' AND e_date>='201107' and 員工代碼(或名稱) = '?????' //=也可以改成like處理

可否另詢問，因為我不是只單查詢07月的而已，原意我是想說新增一個抓取系統日期的欄位為r_time，在where中只要起始日期和結束日期在r_time間的就顯示出

但目前尚未測試出來，故在時間不太足夠的情況下想說能否往新增多筆的想法走

依版主的諫言，若再走回日期區間的話

上面貼上的是r_add.php //新增網頁的程式碼

以下補上r_admin.php //主頁面

r_search.php和r_admin.php其實十分雷同，若有需要在補上 //r_search.php查詢頁面

PS.在r_admin.php 中使用查詢後會跳至r_search.php

PS.跟日期有關的欄位格式均為DATE

非常抱歉...因為我實在無從判斷說怎麼縮減程式碼，我怕錯刪了重要的程式碼就不好了。

r_admin.php
<?php require_once('Connections/connSQL.php'); ?> <?php $colname_Research = "-1"; if (isset($_GET['r_id'])) { $colname_Research = $_GET['r_id']; } mysql_select_db($database_connSQL, $connSQL); $query_Research = sprintf("SELECT * FROM research WHERE r_id = %s", GetSQLValueString($colname_Research, "int")); $Research = mysql_query($query_Research, $connSQL) or die(mysql_error()); $row_Research = mysql_fetch_assoc($Research); $totalRows_Research = mysql_num_rows($Research); $maxRows_Workers = 10; $pageNum_Workers = 0; if (isset($_GET['pageNum_Workers'])) { $pageNum_Workers = $_GET['pageNum_Workers']; } $startRow_Workers = $pageNum_Workers * $maxRows_Workers; mysql_select_db($database_connSQL, $connSQL); $query_Workers = "SELECT worker.no,worker.w_id,worker.w_department1,worker.w_department2,worker.w_job,w_name,research.r_id,research.r_cname,research.r_ename,research.r_page,research.r_subject1,research.r_subject2,research.r_score,research.r_impact,research.r_date,research.r_range1,research.r_range2,research.r_rank,research.r_author1,research.r_author2,research.r_method,research.r_note,research.r_time FROM research JOIN worker USING (w_name) ORDER BY r_id DESC "; $query_limit_Workers = sprintf("%s LIMIT %d, %d", $query_Workers, $startRow_Workers, $maxRows_Workers); $Workers = mysql_query($query_limit_Workers, $connSQL) or die(mysql_error()); $row_Workers = mysql_fetch_assoc($Workers); if (isset($_GET['totalRows_Workers'])) { $totalRows_Workers = $_GET['totalRows_Workers']; } else { $all_Workers = mysql_query($query_Workers); $totalRows_Workers = mysql_num_rows($all_Workers); } $totalPages_Workers = ceil($totalRows_Workers/$maxRows_Workers)-1; $queryString_Workers = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Workers") == false && stristr($param, "totalRows_Workers") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Workers = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Workers = sprintf("&totalRows_Workers=%d%s", $totalRows_Workers, $queryString_Workers); if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $currentPage = $_SERVER["PHP_SELF"]; mysql_select_db($database_connSQL, $connSQL); $query_RecPerformance = "SELECT * FROM performance"; $RecPerformance = mysql_query($query_RecPerformance, $connSQL) or die(mysql_error()); $row_RecPerformance = mysql_fetch_assoc($RecPerformance); $query_RecPerformance = "SELECT * FROM performance"; $RecPerformance = mysql_query($query_RecPerformance, $connSQL) or die(mysql_error()); $row_RecPerformance = mysql_fetch_assoc($RecPerformance); $totalRows_RecPerformance = mysql_num_rows($RecPerformance); $MM_paramName = ""; // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters // create the list of parameters which should not be maintained $MM_removeList = "&index="; if ($MM_paramName != "") $MM_removeList .= "&".strtolower($MM_paramName)."="; $MM_keepURL=""; $MM_keepForm=""; $MM_keepBoth=""; $MM_keepNone=""; // add the URL parameters to the MM_keepURL string reset ($_GET); while (list ($key, $val) = each ($_GET)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepURL .= "&".$key."=".urlencode($val); } } // add the Form parameters to the MM_keepURL string if(isset($HTTP_POST_VARS)){ reset ($HTTP_POST_VARS); while (list ($key, $val) = each ($HTTP_POST_VARS)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepForm .= "&".$key."=".urlencode($val); } } } // create the Form + URL string and remove the intial '&' from each of the strings $MM_keepBoth = $MM_keepURL."&".$MM_keepForm; if (strlen($MM_keepBoth) > 0) $MM_keepBoth = substr($MM_keepBoth, 1); if (strlen($MM_keepURL) > 0) $MM_keepURL = substr($MM_keepURL, 1); if (strlen($MM_keepForm) > 0) $MM_keepForm = substr($MM_keepForm, 1); // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters // create the list of parameters which should not be maintained $MM_removeList = "&index="; if ($MM_paramName != "") $MM_removeList .= "&".strtolower($MM_paramName)."="; $MM_keepURL=""; $MM_keepForm=""; $MM_keepBoth=""; $MM_keepNone=""; // add the URL parameters to the MM_keepURL string reset ($_GET); while (list ($key, $val) = each ($_GET)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepURL .= "&".$key."=".urlencode($val); } } // add the Form parameters to the MM_keepURL string if(isset($HTTP_POST_VARS)){ reset ($HTTP_POST_VARS); while (list ($key, $val) = each ($HTTP_POST_VARS)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepForm .= "&".$key."=".urlencode($val); } } } // create the Form + URL string and remove the intial '&' from each of the strings $MM_keepBoth = $MM_keepURL."&".$MM_keepForm; if (strlen($MM_keepBoth) > 0) $MM_keepBoth = substr($MM_keepBoth, 1); if (strlen($MM_keepURL) > 0) $MM_keepURL = substr($MM_keepURL, 1); if (strlen($MM_keepForm) > 0) $MM_keepForm = substr($MM_keepForm, 1); // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters // create the list of parameters which should not be maintained $MM_removeList = "&index="; if ($MM_paramName != "") $MM_removeList .= "&".strtolower($MM_paramName)."="; $MM_keepURL=""; $MM_keepForm=""; $MM_keepBoth=""; $MM_keepNone=""; // add the URL parameters to the MM_keepURL string reset ($_GET); while (list ($key, $val) = each ($_GET)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepURL .= "&".$key."=".urlencode($val); } } // add the Form parameters to the MM_keepURL string if(isset($HTTP_POST_VARS)){ reset ($HTTP_POST_VARS); while (list ($key, $val) = each ($HTTP_POST_VARS)) { $nextItem = "&".strtolower($key)."="; if (!stristr($MM_removeList, $nextItem)) { $MM_keepForm .= "&".$key."=".urlencode($val); } } } // create the Form + URL string and remove the intial '&' from each of the strings $MM_keepBoth = $MM_keepURL."&".$MM_keepForm; if (strlen($MM_keepBoth) > 0) $MM_keepBoth = substr($MM_keepBoth, 1); if (strlen($MM_keepURL) > 0) $MM_keepURL = substr($MM_keepURL, 1); if (strlen($MM_keepForm) > 0) $MM_keepForm = substr($MM_keepForm, 1); $queryString_RecWorkers = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_RecWorkers") == false && stristr($param, "totalRows_RecWorkers") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_RecWorkers = "&" . htmlentities(implode("&", $newParams)); } } $queryString_RecWorkers = sprintf("&totalRows_RecWorkers=%d%s", $totalRows_RecWorkers, $queryString_RecWorkers); ?>

where s_date<='201101' AND e_date>='201107' 可以查到 2011年1月到7月的值。

看樣子你並非是全新的開發，而是利用原有的程式做改良。的確會受到一些限制。

你可以先告訴我現有的資料節構及其資料的儲存方式，我可以幫你想如何利用現有資料來做到你想要的功能。
或是我有pm給你我的聯絡方式。你也可以私下找我尋問。(但記得還要回來這邊回報你的研究及開發的成果)

恩...版大您的PM我好像沒看到..請問是站內信嗎?

相關資料表，我想說私下聯絡您不知道您方便嗎..

在站內信我有留下我的聯絡方式。或是你直接去我的論壇找也行。