PHP webpage with MySQLi recordset does not display - at all!

AGAIN! I'm trying to build a PHP page that is to insert data into a MYSQL dB but the page does not display in a browser. I've added a "display error" script to the page top but even this does not display any errors. I'm attaching the page and sure could use some help trying to figure out what now is wrong.

Are you sure you have uploaded the two files required at the top of the page? If those have been uploaded I may need to get FTP access to fully debug the page. It doesn't appear to be a code problem on this page itself.

The page "automagically" began working this morning - and I haven't touched or changed ANYTHING!! But now I am trying to move on and complete its build by adding an Insert Record behavior. However, I am now getting a generic error "There is an error in your SQL syntax." I cannot locate where that error is -- could you please take a peek at the page and see if you can locate where I've goofed it up? When I remove the Insert Record code, the page opens fine, but when the code is re-inserted via the Webassist GUI, I get the generic SQL syntax error. Webassist's GUIs do not display any errors or hint of anything wrong.

You probably uploaded the necessary include files and that is why it started working. That sounded like the cause of the issue in the first place, so if you uploaded again and clicked "yes" to include dependent files it would have appeared to automagically work without updating anything.

Can you give me FTP access to the page? I can use that to debug. It could be reserved words as column names, or leaving a blank field value in a column that doesn't allow nulls.

I think there is a setting you can update in the include file to set debug=true and that would give you the full error message, but I'd gladly help you debug if you give me FTP access.

I've changed suspect column titles to avoid any reserved word conflicts and I've modified the " $this->Debug = true;" line in the mysqli/queryobj.php file which now gives a more expanded error:

INSERT INTO opp_workassign (Submit Date, Name, Username, Email, Phone, Building, Floor, Room, Category, Urg_Norm, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Date, Name, Username, Email, Phone, Building, Floor, Room, Category, Urg_Norm, D' at line 1

Any ideas what is causing the error?

UPDATE: I just removed all of the MySQLi behaviors and replaced them with the DW CS6 legacy behaviors - and everything worked perfectly - 1st try. I re-applied the MySQLi behaviors and the SQL syntax error returned. So it is something involving the MySQLi extension that is causing my grief. Does this update give you any clues?? I really need to resolve this since this page is expected to be placed into production tomorrow.

It looks like it is an issue with spaces in column names. We will have to do an update to the extension to allow for that. For now, I think it would work if you just update the column "Submit Date" to "Submit_Date" in the database.

Thanks Ray. I'll try your suggestion when I return to my office and will let you know how I fare. BTW, I really appreciate your quick responses to my issues. I'm mostly working under tight deadlines (who isn't?) and often need trouble-shooting resolution quickly -- so you're a much appreciated life saver in my case.

2015-07-16: WOW! I would have never spotted that. I got rid of the space in Submit Date and the insert now works. Thanks for your sharp eye.

The email code appears to be applied correctly and should work. What hosting company are you using? Email won't work from your localhost, because XAMPP, MAMP, and WAMP don't include an SMTP server which is necessary to send email from a web page. It may work live if you have only been doing local testing.

If you are testing live, then it may be an issue with the smtp server settings in the email. If you let me know the hosting company I can try to look up the correct settings.

OK. I started all over from scratch using the legacy DWCS6 server behaviors: I built the form with dynamically-fed dropdowns, added an insert behavior, added a PHP mail function (took all of ten minutes) and EVERYTHING works perfectly, including the email (so smtp is working on our server - - it is not being hosted outside of our Firewall.)

I'm sorry for your frustration. Whether the email works or not has nothing to do with the MySQLi code or insert. It has everything to do with the difference in the email code.

If you provide FTP information I can debug the first page and let you know why the email didn't send. It is hard to tell by just looking through the code, but if I'm able to investigate I'm sure I can figure it out.