check box

[Anon]

i havecheck boxes where default values are either checked or unchecked.now, when i try to update them and save it i need to see the updated value in my form.I did this stuff with my text fields, it is working perfect.But, it is not the same with the check boxes.Any suggestions would be highly appreciated.

<?php

include "dbconnection.ini";

?>
<form name="frm_main" method="post">

<?
include "edit.ini";

?>

<br></b><input type="submit" name="save_button" value="Save"></br>
<input type="hidden" name="frm_save" value="1">
</form>

----->edit.ini<-----------

<?
if ($frm_save == 1)
{

    $sql = "update Statement";
    $result = ibase_query($connection, $sql);

}
$db = 'Select statement';
$query = ibase_query($connection, $db);
while ($row = ibase_fetch_object($query)) {
$test=$row[1];
}
?>

<input type="checkbox" name=field value = "<? echo $row[1]; echo $test; ?>">

[bastien]

check boxes either come 'on' or blank for off...check this by passing the data in the url via get method of the form.

i usually take the 'on' or 'off'/'blank' and change the value into 1 for 'on' or null for 'off' in the DB..then when queried i can check the value and change the marker to CHECKED to create the check in the boc

<?
echo "<input type="checkbox" name=field "
if ($x==1){
echo "value=CHECKED"
}
echo ">" //close the input for the box

?>

hth

bastien

[Anon]

hi bastien

could you please explain me further.or would you pls insert this code into my code, which i have written before.

thank you