怎么修改这段代码？如果成功则加分，谢谢大家

Question

如下试试：
for($i=0;$i<=4;$i++)
{
$date=ereg_replace("<"," ",$date[$i]);
$summary=ereg_replace("<"," ",$summary[$i]);
$bank=ereg_replace("<"," ",$bank[$i]);
$account=ereg_replace("<"," ",$account[$i]);
$money=ereg_replace("<"," ",$money[$i]);
$sql="insert into commend (date,summary,bank,account,money) values(";
$sql=$sql.sqlstr($date).",";
$sql=$sql.sqlstr($summary).",";
$sql=$sql.sqlstr($bank).",";
$sql=$sql.sqlstr($account).",";
$sql=$sql.sqlstr($money).")";
//print($sql);
mysql_query($sql,$mysql_link);
}
header("location:guanli.php");
?>==>
$sql="insert into commend (date,summary,bank,account,money) values";
for($i=0;$i<=4;$i++)
{
if($i==0)$sql .= "(";
else $sql .= ",(";
$date=ereg_replace("<"," ",$date[$i]);
$summary=ereg_replace("<"," ",$summary[$i]);
$bank=ereg_replace("<"," ",$bank[$i]);
$account=ereg_replace("<"," ",$account[$i]);
$money=ereg_replace("<"," ",$money[$i]);
$sql=$sql.sqlstr($date).",";
$sql=$sql.sqlstr($summary).",";
$sql=$sql.sqlstr($bank).",";
$sql=$sql.sqlstr($account).",";
$sql=$sql.sqlstr($money).")";
$sql .= ")";
}
print($sql);
if(mysql_query($sql,$mysql_link))
header("location:guanli.php");
else echo "error!";
?>

Answer 1

还是不行啊！连不上数据库了！出现这种错误insert into commend (date,summary,bank,account,money) values('21','32132','2321','323','2323')),('1','2','3','2','3')),('','','','','')),('','','','','')),('','','','',''))error!

Answer 2

还是不行啊！连不上数据库了！出现这种错误
insert into commend (date,summary,bank,account,money) values('21','32132','2321','323','2323')),('1','2','3','2','3')),('','','','','')),('','','','','')),('','','','',''))error!
括号太乱,先把括号修正好,
另外建议提交时,采用数组

Answer 3

把name中间的数字全去掉在试试
如
        </tr>
          <tr bgcolor="#EFFFEF"> 
            <td height="18" align="center"><font size="2"> 
              <input name="date[0]" type="text">
              </font></td>
            <td bgcolor="#EFFFEF"> <input name="summary[0]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="bank[0]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="account[0]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="money[0]" type="text"></td>
          </tr>
==>
        </tr>
          <tr bgcolor="#EFFFEF"> 
            <td height="18" align="center"><font size="2"> 
              <input name="date[]" type="text">
              </font></td>
            <td bgcolor="#EFFFEF"> <input name="summary[]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="bank[]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="account[]" type="text"></td>
            <td bgcolor="#EFFFEF"><input name="money[]" type="text"></td>
          </tr>