[Resolved] Php + Database

[obrienkev]

Hi all,

I have created a html form which contains a checkbox.
When the user checks this box and hit submit a value of 'yes' should be stored in the database.

Here is my checkbox code...
<input name="paid" type="checkbox" id="paid" value="yes">

Here is insert code...
if ($paid && $enter) //$enter is submit button
{
@ $db = mysql_connect('localhost', 'user', 'passwd');

if (!$db)
{
echo ' Could not connect to db.';
exit;
}

// select which database to use
mysql_select_db('bookings');
$query = mysql_query("INSERT INTO customer (paid) VALUES ('".$paid."')");

$result = mysql_query($query);

echo mysql_affected_rows($result).' details inserted into database';

}

My field for paid in the db is...char(3), null, default(no)

I would be very grateful for your help. Thanks very much.

Kevin.

[YappyDog]

Is there a question in here? Is it working? Not working?

Related question: Shouldn't your insert into the customer table also include some sort of customer identifier so that you know who it is that paid?

[obrienkev]

Yes sorry, that is my problem. How do I insert into which customer has paid??

[YappyDog]

Well, I don't know your column names or variable names, but you would do something like:

Insert into customer (customerid, paid) VALUES ($id, '$paid')