Multiple Checkboxes Help Needed

[Ralph Freshour]

I'm using MySQL to display data on a web page - fitting about 10
records of data per screen - I'm including a checkbox with each record
so that I can check it and when the submit button is clicked the
called .php script will delete those records that are checked.

I'm creating the records from the table with the checkboxes ok (I
think):

<INPUT TYPE='checkbox'
NAME='frm_chk_d elete[$php_delete_cou nter]'>Delete

I use a php counter var to give each checkbox record item a unique
NAME and this seems to work OK - producing
frm_chk_delete[0]
frm_chk_delete[1]
etc.

The problem I'm having is the POST called script - I don't seem to be
detecting enabled checkboxes to delete them:

$php_mem_name = Trim(StrToLower ($php_name));
$php_SQL = "SELECT * FROM basics WHERE member_name =
'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
$php_delete_cou nter = 0;
while ($php_row = mysql_fetch_obj ect($php_result ID))
{
if ($frm_chk_delet e[$php_delete_cou nter] == 'on')
{
$php_SQL = "DELETE FROM basics WHERE member_name =
'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
}
$php_delete_cou nter++;
}

Can anyone see what I'm doing wrong or that I'm not understanding
about how to do this task?

Thanks...

[Geoff Berrow]

I noticed that Message-ID: <34************ *************** *****@4ax.com>
from Ralph Freshour contained the following:

Can anyone see what I'm doing wrong or that I'm not understanding
about how to do this task?

You have to give the checkbox a value to return if checked. e.g
<INPUT TYPE='checkbox'
NAME="frm_chk_d elete[$php_delete_cou nter]" value="1">

and detect like so...

if ($frm_chk_delet e[$php_delete_cou nter] == 1)

--
Geoff Berrow
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Ralph Freshour]

I tried that but it only detects the first checkbox - if I have 5
records displayed and I check all 5 and then click on submit, only the
first checkbox is detected as checked, the others do not get detected.

I also tried:

VALUE=<?php echo $php_delete_cou nter ?>

in the checkbox so each would get a unique value but that didn't seem
to matter either - maybe my syntax is wrong somewhere?:

<INPUT TYPE="checkbox" NAME="frm_chk_d elete[$php_counter]"
VALUE="1">Delet e

Then in my called post php script:

$php_SQL = "SELECT * FROM names WHERE member_name =
'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
$php_delete_cou nter = 0;
while ($php_row = mysql_fetch_obj ect($php_result ID))
{
if ($frm_chk_delet e[$php_delete_cou nter] == 1)
{

}
$php_delete_cou nter++;
}
On Thu, 18 Sep 2003 07:24:16 +0100, Geoff Berrow <$b**@ckdog.co. uk>
wrote:

I noticed that Message-ID: <34************ *************** *****@4ax.com>
from Ralph Freshour contained the following:

Can anyone see what I'm doing wrong or that I'm not understanding
about how to do this task?

You have to give the checkbox a value to return if checked. e.g
<INPUT TYPE='checkbox'
NAME="frm_chk_ delete[$php_delete_cou nter]" value="1">

and detect like so...

if ($frm_chk_delet e[$php_delete_cou nter] == 1)

[Jon Kraft]

Ralph Freshour <ra***@primemai l.com> wrote:

I tried that but it only detects the first checkbox - if I have 5
records displayed and I check all 5 and then click on submit, only the
first checkbox is detected as checked, the others do not get detected.

<INPUT TYPE="checkbox" NAME="frm_chk_d elete[$php_counter]"
VALUE="1">Delet e

Hi Ralph,

How do you build up the list of checkboxes? Are you sure $php_counter is
incremented for each checkbox name?

JOn

[Geoff Berrow]

I noticed that Message-ID: <ei************ *************** *****@4ax.com>
from Ralph Freshour contained the following:

<INPUT TYPE="checkbox" NAME="frm_chk_d elete[$php_counter]" .... if ($frm_chk_delet e[$php_delete_cou nter] == 1)

Could this be your problem?

--
Geoff Berrow
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Chung Leong]

A simpler (as well as quicker) way to do this would be to use the id
of the record as the value in the checkbox. Thus:

$res_id = mysql_query("SE LECT * FROM basics");
while($row = mysql_fetch_row ) {
$id = $row[0];
echo <<<CHECKBOX
<input type="checkbox" name="frm_chk_d elete[]" value="$id"> ...
CHECKBOX;
}

When the form is submit, the ids those records that are selected will
be in frm_chk_delete. All you have to do to delete them is to run a
DELETE using the IN keyword.

$list_of_ids = implode(",", $frm_chk_delete );
mysql_query("DE LETE FROM basics WHERE basics_id IN ($list_of_ids)" );

$php_SQL = "SELECT * FROM basics WHERE member_name =

'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
$php_delete_cou nter = 0;
while ($php_row = mysql_fetch_obj ect($php_result ID))

Ralph Freshour <ra***@primemai l.com> wrote in message news:<34******* *************** **********@4ax. com>... I'm using MySQL to display data on a web page - fitting about 10
records of data per screen - I'm including a checkbox with each record
so that I can check it and when the submit button is clicked the
called .php script will delete those records that are checked.

I'm creating the records from the table with the checkboxes ok (I
think):

<INPUT TYPE='checkbox'
NAME='frm_chk_d elete[$php_delete_cou nter]'>Delete

I use a php counter var to give each checkbox record item a unique
NAME and this seems to work OK - producing
frm_chk_delete[0]
frm_chk_delete[1]
etc.

The problem I'm having is the POST called script - I don't seem to be
detecting enabled checkboxes to delete them:

$php_mem_name = Trim(StrToLower ($php_name));
$php_SQL = "SELECT * FROM basics WHERE member_name =
'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
$php_delete_cou nter = 0;
while ($php_row = mysql_fetch_obj ect($php_result ID))
{
if ($frm_chk_delet e[$php_delete_cou nter] == 'on')
{
$php_SQL = "DELETE FROM basics WHERE member_name =
'".$php_mem_nam e."'";
$php_resultID = mysql_query($ph p_SQL, $php_linkID);
}
$php_delete_cou nter++;
}

Can anyone see what I'm doing wrong or that I'm not understanding
about how to do this task?

Thanks...