To arm or not to arm, that is the question

SQL statements

Create table

CREATE TABLE tblTypesOfCarry (
pmkCarryTypesID INT AUTO_INCREMENT PRIMARY KEY,
    fldIssueType varchar(12),
    fldDescription varchar(700),
    fldPrevelance varchar(500)
);

Populate table with data

INSERT INTO tblTypesOfCarry(fldIssueType, fldDescription, fldPrevelance) VALUES

('May issue', 'Type of permitting law where the issuing of a permit is at the sole discretion of a local authority, typically a police department. The applicant must provide a proper reason for applying for a carry permit and in many cases the sole reason of self defense does not apply. Within a may issue jurisdiction the local authority does not need to provide a substantive reason for rejecting an application for a permit. The problem with this style is that it opens the door for local authorities to arbritrarily reject the issuing and renewal of permits without proper cause.','Currently nine states have a may issue statute in place. An important note:The issuing of permits depend on the local authority, typically on the county level. Meaning that alhtough there is a may issue statute on the state level, many county authorities are more liberal when issuing carry permits, essentially making them shall issue in practice.'),

('Shall Issue', 'A less resctrictive form of permitting where a license to carry is still required, and several requirements must be reached in order to obtain that license, but the local authoritiy is required by law to grant the permit if the applicant reaches all eligible criteria. And the applicant does not need to provide a proper cause to apply for a permit.', 'Currently twenty states, including the islands of Puerto Rico and Guam, have an official shall issue statute.'),

('No Issue', 'The most restricitve type of permitting law where only in under very limited circumstances is a person allowed to carry a weapon on their person. While although there is a permit system inplace, the authorities will rarely issue a conceal carry permit to an ordniary person. Exemptions to this rule could be applied to on and off duty military personel, security guards, retired law enforcement, or anyone with an active threat agaisnt them.', 'While there is no official no issue statute on the state level in the United States, there are states such as New Jersey and many major cities and counties in New York, Massachusetts, and California where the local authorities almost never issue carry permits.');
        

Select data for display

SELECT fldIssueType, fldDescription, fldPrevelance FROM tblTypesOfCarry
        

Create table to save forms data

CREATE TABLE tblInformation (
        pmktblInformationId INT AUTO_INCREMENT PRIMARY KEY,
        fldFirstName varchar(50),
        fldLastName varchar(50),
        fldEmail varchar(50),
        fldHomeDefense boolean,
        fldHunting boolean,
        fldRecreation boolean,
        fldOpinion varchar(80),
        fldAlternative text
);

Populate table with data

        INSERT INTO tblInformation(fldFirstName, fldLastName, fldEmail, fldHomeDefense, fldHunting, fldRecreation, fldOpinion, fldAlternative) VALUES
        ('Paul', 'De Leon', 'pdeleon2@uvm,edu', '1', '1', '1', 'I think it's an excellent idea', 'I support permitless carry. End of story. No alternatives.');

Select data for display

SELECT fldFirstName, fldLastName, fldEmail, fldHomeDefense, fldHunting, fldRecreation, fldOpinion, fldAlternative FROM tblInformation