Multiple Checkbox Deletes..

[Anon]

I'm having a problem in doing multiple deletes from a database using this technique
(See below)
**
INPUT TYPE=\"checkbox\" NAME=\"strDeleteMe[]\" VALUE=\"1\"></TD></TR>";

I'll then loop thru when posting this form
to determine which records (say 1-10) are deleted from the list.

But.. when choosing the last item in the list, it deletes the first item..

here's what I'm using to determine if the
checkbox was checked:
if ($strDeleteMe[$i] == "")
I'll do an update
else
i'll do a delete..

Thanks in advance for the help.

[Anon]

Nevermind guys... i found a good solution.

Just added a counter inside the array and dynamiclly created the ID to delete in the VALUE.

Sometimes it helps to type out the question 🙂

[ebuuu]

Hmm, sorry, could you explain in detail what d'you mean? Dynamic creating of IDs is realm on DB engine... imho...
Usually i do like this:

When generating checkbox:

function list_zhurs($type, $name){
global $$name; //for listbox to check priviously selected value
$result = mysql_query("SELECT id, name FROM zhurs") or die ("select from zhurs");

//assume $type=='AS_CHECKBOX '
case "AS_CHECKBOX":
if(mysql_num_rows($result)>0){
echo "<table border=0>";

  while ($rws = mysql_fetch_row($result)){
   echo "<tr><td><input type=checkbox name=".$name."[$rws[0]]>$rws[1]</td></tr>";
  }
   echo "</table>";
 } else {
   echo "no zhurs yet :(";
 }

break;

Then we call it somelike this
...
list_shurs ("AS_CHECKBOX", "zhurs_to_del");
....
And processing request:

$items = "(";

if (is_array($zhurs_to_del)){
while (list ($key, $val) = each ($zhurs_to_del)) {
$items .="$key,";
}

 $items = substr($items, 0, -1);

 $items.=")";

  mysql_query ("DELETE FROM zhurs WHERE id IN $items") or die("delete from zhurs in del_menu_type");

//AND DON"T FORGET TO DELETE ALL RELATIONS!!!!! (if you using MySQL or any underelational DBE 🙂

cheeeeees!