Checkboxes Query Problem..need help

[harris97]

I need help please..
i have writen simple PHP coding to show my records. Here is preview : (NO is primary key, checkboxes NAME=delete<%=$i%> VALUE=yes)

NO | NAME |
1 | Ashy | [v] // checked or unchecked
2 | Bosy | [v] // checked = delete
3 | Chesy| [v] // unchecked = do not delete

DeleteButton

so..when records are displayed, i can checked or unchecked for each record. And when i click submit button, all records that have been checked will be deleted.

Here is part of my PHP code:

if ($Button == "DeleteButton") {
$connect = mysql_pconnect("localhost", "user", "pass");
$db = mysql_select_db("mydb");
$choose=mysql_query("select NO, NAME from mytable where NO='$NO'");
$num_rows = mysql_num_rows($choose);

$i=0;
while ($row=mysql_fetch_row($choose)) {
$i++;
$delete = $HTTP_POST_VARS["delete$i"];
$NO= $row[0];
$NAME=$row{1];
$query = "Delete mytable (NO, NAME) values ('$NO', '$NAME') where $delete='yes'";
$results = mysql_query($query); }
}

that code still have error. I don't have any idea how to query that checkboxes. Any body can help? thanks so much.

[[deleted]]

Step 1: read the MySQL manual about delete queries etc.
The query you use here is bad to say the least.

Step 2: You can print a list of checkboxes and retreive their value using arrays.
On the page where you select which items to delete you can print:
<input type=checkbox name=deleteme[] value=recordID>

After submitting you should have an array called "deleteme" that holds all "recordID"s of all the selected checkboxes.

[cvincent]

I guess you have a script that prints your records, and each checkbox created should be like:
<INPUT TYPE=CHECKBOX NAME=delete[$NO] VALUE=yes>
and when you hit submit, the page that is in the ACTION of the form should be:
<?
$connect = mysql_pconnect("localhost", "user", "pass");
$db = mysql_select_db("mydb");
foreach($delete as $item) {
if($item == "yes") {
$query = "DELTE FROM mytable WHERE NO = '$item'";
$results = mysql_query($query);
}
}
//anything else you want done
?>

[cvincent]

I just realized I totally messed that up. the PHP should be:
<?
$connect = mysql_pconnect("localhost", "user", "pass");
$db = mysql_select_db("mydb");
foreach(array_keys($delete) as $key) {
if ($delete[$key] == "yes") {
$query = "DELTE FROM mytable WHERE NO = '$key'";
$results = mysql_query($query);
}
}
?>