to set a flag(value) to a column

chinni_77

hello,

I've set of records displaying on a form from a table.At the end of each record set, i've a check box.Now, when i check this box and click a button, i've to display the same form with two images and also to set a value 1 or 0 to a column in a table.

To be more precisely, what i am trying to do is......

I'm displaying the records from a table and i would like to delete a record from the table.
So, at the end of each record set, i'm displaying a check box.when i check this box and click a button, a flag is set to a value in the table(i.e to the row) and then the same form will display two buttons or images which shows, do you really want to delete or cancel delete.
That means, i would not like to delete the record in single step, but in two steps.
So, in order to store the flag value, i inserted a new column called delete to the table.

Hope i expressed clearly.

could somebody pls tell me how can i implement this.

thanks in advance

zenon

I remember I did something similar a 4 months ago...
simply, while you retrieve your recordset, you have to build (dynamically) a checkbox linking to a javascript function with the number of the row or id;

chinni_77

is it not possible to do with out using java script?

zenon

I think yes...
you can build a checkbox's array (Example:
<INPUT TYPE="checkbox" NAME="chk[0]">
<INPUT TYPE="checkbox" NAME="chk[1]">
) and on the submit, check every checkbox with a loop (you have to know how many checkbox you got, considering number of checkbox = number of rows). on php, you can view checkbox value after a submit calling his name; so if chkbox was checked $cgkbox[] = 'on'; you can try it with a page like that:

<BODY>
<? echo "value 1:".$chk[0]."<br>";
echo "value 2:".$chk[1];
?>
<FORM METHOD=POST ACTION="">
Check 1 <INPUT TYPE="checkbox" NAME="chk[0]"><br>
Check 2 <INPUT TYPE="checkbox" NAME="chk[1]">
<INPUT TYPE="submit">
</FORM>

</BODY>
</HTML>

so 2nd form will ask to delete if any chkbox value will be = 'on'