<input type="checkbox">
| From: | John Taylor-Johnston | Date: | Sat, 15 Mar 2008 03:00:41 +0000 |
| Subject: | <input type="checkbox"> | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-271631@lists.php.net to get a copy of this message | ||
Am coding something. Cannot quite clear my head. I know what my SQL looks like. I just cannot see clearly to input it.
What is $_POST["checkregion"] going to look like? Is it going to have all the convenient commas I will need in my SQL? Or do I have to parse God knows how many checkboxes?
John
<input type="text" name="Name">
<label><input type="checkbox" name="checkregion" value="Knowlton">A</label>
<label><input type="checkbox" name="checkregion" value="Thetford Mines">A</label>
$sql ='insert into
database.table (Nom ,checkregion)
values ('John', 'Knowlton,Thetford Mines') ';
CREATE TABLE IF NOT EXISTS GLApplications (
Name varchar(200) NOT NULL,
set(''Knowlton','Thetford Mines','Clarenceville','Sawyerville','Laval') NOT NULL,
dummy int(10) NOT NULL auto_increment,
PRIMARY KEY (dummy)
)