how to access the ID?

In the website I'm designing the admin list page shows fields such as Name, Email, Username and St开发者_JAVA百科atus(whether active or inactive users). My database has a table called admin. The fields are iAdminId, vFirstName, vLastName, vEmail, vUserName, vPassword, vFromIP, vFromIP, dLastLogin, and eStatus. In the equivalent PHP page (the admin list page) I am adding an active & inactive button. Check boxes are present with each row. The number of rows that an administrator chooses will be updated(after confirmation, of course) once he/she clicks on Active or Inactive button.

My javscript code for activation is:

function activeRecord()
  {
    var count = getCount();
    if(count == 0)
    {
      alert("Please enter some records for activation first!!");
    }
    else
    {
      var c = confirm("Do you wish to activate?");
      if(c==true)
      {
        document.frm.mode.value="Active";
        document.frm.submit();
      }
      else
      {
        alert("You had wrongly selected 'Active' option!!");
      }
    }
  }

getCount returns the number of selected records. And PHP code is

if($mode=="Active")
  {
    for($i=0;$i<count($_POST['ch']);$i++)
    {
      $active = "UPDATE admin SET eStatus = 'Active' WHERE iAdminId = '" . $_POST['ch'][$i] . "'";
      $result = mysql_query($active,$conn);
    }
  }

Even after selecting its not deleting the selected records. I tried echoing also.

echo $active = "UPDATE admin SET eStatus = 'Active' WHERE iAdminId = '" . $_POST['ch'][$i] . "'";

"ch" is the array name for all the checkboxes

It shows: UPDATE admin SET eStatus = 'Inactive' WHERE iAdminId = ''

Any help will be appreciated. Thanks in advance

ch is used as:

Pls help. Its urgent. Thanks everybody

In your case $_POST['ch'] should be an array. Check if that's true by placing var_dump($_POST['ch']) in your PHP script.

Also your checkboxes should use the same name (<input name="ch[]" value="Element-ID" />).

There's no need in adding an index in the brackets. If you do so, your for-Loop (which could be replaced by foreach) won't work since you're just checking the length and iterate through the array with the wrong keys.

Sorry for bothering everybody and loads of thanks for paying the interest in solving my problem.

I guess i needed an extra pair of eyes for checking my code. As @fabsn asked i rechecked my code. I had entered value for the check boxes. So there was no chance of them going blank. It was all just a minor spelling mistake. Its corrected now and working absolutely fine now. I guess i need to be more careful from now onwards so that i dont bother you all unnecessarily.

Thanks again