[請益] 刪掉資料庫內的資料 找不到錯誤...@"@

[iversonjimmy (還沒想到捏)]

以下是我兩個php檔

1.php

<FORM action=2.php method=POST">
<table cellspacing=1 cellpadding=5 width=50% bgcolor=#E7E3E7>
<?
$link_ID = mysql_connect("localhost","root","");
//連接MySQL伺服器
mysql_select_db("talk");
//使用contact資料庫
mysql_query("set character set big5");
$str1="select * from bbs_form";
$result1=mysql_query($str1,$link_ID);
$l = mysql_num_rows($result1);
mysql_query("set character set big5");
echo "<tr height=23 align=center>";
echo "<td bgcolor=#3366CC>鎖版</td>";
echo "<td bgcolor=#3366CC>論壇</td>";
echo "<td bgcolor=#3366CC>版主</td></tr>";
for ($a=0; $a < $l ; $a++){
        $row0 = mysql_result($result1,$a,"id");
        $row1 = mysql_result($result1,$a,"title");
        $row2 = mysql_result($result1,$a,"username");
echo "<tr height=23 align=center class='cbg'>";
echo "<td><input type=checkbox name=lock$a value=$a></td>";
echo "<td>$row1</td>";
echo "<td>$row2</td></tr>";
};?>
</table>
<INPUT Type="submit" value="刪除">
</form>

2.php

<?php
$link_ID = mysql_connect("localhost","root","");
//連接MySQL伺服器
mysql_select_db("talk");
//使用contact資料庫
mysql_query("set character set big5");
$str1="select * from bbs_form";
$result1=mysql_query($str1,$link_ID);
$l = mysql_num_rows($result1);
mysql_query("set character set big5");

for($a=0;$a<$l;$a++)
        {
        if(isset($_REQUEST["lock"]))
        {
        $row0 = mysql_result($result1,$a,"id");
        $row1 = mysql_result($result1,$a,"title");
        $row2 = mysql_result($result1,$a,"username");
        $query1="DELETE FROM `bbs_form` WHERE `title`='$row1'";
        mysql_query($query1);

        }}


header ("Location:1.php");
?>

想請問 我錯在哪裡壓??

選一篇文章案刪除 卻都沒有動靜...已經困擾我兩天了@@"

可以幫忙一下嗎? 謝謝~

--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.130.189.39
※ 編輯: iversonjimmy    來自: 140.130.189.39       (11/01 17:38)
※ 編輯: iversonjimmy    來自: 140.130.189.39       (11/01 17:38)
推 buganini:2.php $result1$a
※ 編輯: iversonjimmy    來自: 140.130.189.39       (11/01 17:53)
推 iversonjimmy:不好意思 剛剛修改忘記補上逗號了...@"@
→ iversonjimmy:還是不行....
推 iversonjimmy:耶~~我找到錯誤了~~真開心~ 謝謝你們!!
→ fatcats:是因為數字開頭嗎...@@"
推 iversonjimmy:是在2.php裡 if敘述的lock這裡 忘記加$a了....@"@