urgent need of smart peoples advice.
I have quite a couple of problems with the whole form which i'm busy with but this one should be so simple but I dont know why Im struggling with it.
The thing is, I have a page where a new client is added, at the top is a checkbox which is checked when a client fals under a b-listed category, meaning that some additions to payments do not apply to them. But, its not writing to the database at all. why not? Please help, below is my code for the text box. The field in the database is as an int(1) type.
<table cellpadding=5 cellspacing=3 border=0 width=550>
<tr><td class=\"side\" width=\"120\">ID #:</td>
<td><input type=\"text\" name=\"client_IDNO\" size=20/></td>
<td class=\"side\" width=\"120\">B-Listed:</td>
<td><input type=\"checkbox\" name=\"client_b_listed\"></td>
</tr>
this is where I write to the database:
if (isset($POST['form_complete']))
{
if (isset($POST['client_b_listed']) == 'on')
{
//echo $POST['client_b_listed'];
$query = "INSERT INTO client (client_IDNO, client_persal, client_firstname, client_lastname, client_tel, client_fax, client_email, client_cell, client_address, client_work_address, client_postal_address, client_default_payday, client_latest_paydate, client_default_paypoint_ID, client_b_listed, client_admin_ID) VALUES (" .
"'" . $POST['client_IDNO'] . "'," .
"'" . $POST['client_persal'] . "'," .
"'" . $POST['client_firstname'] . "'," .
"'" . $POST['client_lastname'] . "'," .
"'" . $POST['client_tel'] . "'," .
"'" . $POST['client_fax'] . "'," .
"'" . $POST['client_email'] . "'," .
"'" . $POST['client_cell'] . "'," .
"'" . $POST['client_address'] . "',".
"'" . $POST['client_work_address'] . "',".
"'" . $POST['client_postal_address'] . "',".
"'" . $POST['client_default_payday'] . "'," .
"'" . $POST['client_latest_paydate'] . "'," .
"'" . $POST['client_default_paypoint_ID'] . "'," .
"'" . $POST['client_b_listed'] . "'," .
"'" . $_SESSION['admin_ID'] . "')";
