Scenario:
I have 3 checkbox on my form and users select all
Checkbox1
Checkbox2
Checbox3
Table structure:
Date, checknames
Goal:
Every time I hit the update button with query behind I want to insert the current date and checkboxnames (see below table)
------------------------------
|Created | checkboxname|
---------------------------------
|10-07-08 |checkbox1 |
---------------------------------
|10-07-08 |checkbox2 |
--------------------------------
|10-07-08 |checkbox3 |
---------------------------------
Problem:
Help to construct my insert query which i know is wrong :(
INSERT INTO dmtable (Created, checkboxname)
VALUES (NOW(),'{checkbox1}', '{checkbox2}','{checkbox3}');