Re: Insert command is failing
> create table complaints (date DATE, email VARCHAR(20), message VARCHAR(250), response VARCHAR(250));
A table without a primary key isnot a real table. It's most always a bad mistake to not give a table a primary key, eg ...
create table complaints (cid int unsigned primary key auto_increment, date DATE, email VARCHAR(20), message VARCHAR(250), response VARCHAR(250));
Read about primary keys and normalisation.
> insert into complaints (date,email,message,response) values ('2015-09-03','tony@gmail.com','Where's my money?','What money?');
Strings containing single quotes must be surrounded with double quotes, or alternatively have the single quotes escaped by the escape character (`\`).