So stuck (check marks in mysql)

[saragoth]

Ok I'm new to this obviously, I'm trying to wrap my mind around how to display a check mark when I do my query page. What I'm trying to do is have staff fill out a form, there are check boxes on this form..

 

<td><form name="form1" action="insert.php" method="post">

<input type="checkbox" name="fac_trans_switch_dca_day" id="fac_trans_switch_dca_day">

<input type="checkbox" name="fac_ups_dca_day" id="fac_ups_dca_day">

 

in the insert.php here is my INSERT stuff

 

$sql="INSERT INTO facility (fac_trans_switch_dca_day,  fac_ups_dca_day)

VALUES

('$_POST[fac_trans_switch_dca_day]',

'$_POST[fac_ups_dca_day]')";

 

each of these are in the mysql db as TINYINT(1)

 

The form works, I can fill it out and it goes through and I see the record but checkboxes have a value of 0 regardless if they are checked or not.

 

Looking for a little direction here and all I've gotten so far in my search is "use bit" and "don't use bit use tinyint(1)" really about to lose my mind! =(

 

thanks,

 

Jeremy

 

 

 

 

 

[roopurt18]

<td><form name="form1" action="insert.php" method="post">

<input type="checkbox" name="fac_trans_switch_dca_day" id="fac_trans_switch_dca_day" value="true" />

<input type="checkbox" name="fac_ups_dca_day" id="fac_ups_dca_day" value="true" />

 

$t = 'fac_trans_switch_dca_day';

$fac_trans_switch_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;

$t = 'fac_ups_dca_day';

$fac_ups_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;

$sql="INSERT INTO facility (fac_trans_switch_dca_day,  fac_ups_dca_day)

VALUES

( {$fac_trans_switch_dca_day}, {$fac_ups_dca_day} )";

[saragoth]

<td><form name="form1" action="insert.php" method="post">

<input type="checkbox" name="fac_trans_switch_dca_day" id="fac_trans_switch_dca_day" value="true" />

<input type="checkbox" name="fac_ups_dca_day" id="fac_ups_dca_day" value="true" />

 

$t = 'fac_trans_switch_dca_day';

$fac_trans_switch_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;

$t = 'fac_ups_dca_day';

$fac_ups_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;

$sql="INSERT INTO facility (fac_trans_switch_dca_day,  fac_ups_dca_day)

VALUES

( {$fac_trans_switch_dca_day}, {$fac_ups_dca_day} )";

 

You are the friggen man!