Insert does not work

Hello,

I can't seem to get insert to work. I used the webassist wizard and associated everything within the form. When I attempting to add a record, the contents of the form are cleared and nothing happens and the page reloads. The re-direct doesn't seem to work. I have attached the page in question. Please let me know what you find as my previous post was not replied to.

On line 5 you have:
if (isset($_POST["AddVariety"]) || isset($_POST["AddVariety_x"])) {

It should be:
if (isset($_POST["AddVarietyButton"]) || isset($_POST["AddVarietyButton_x"])) {

This didn't seem to fix the problem. That code you identified as the problem was generated by We assist. I will investigate it further. As the problem is not fixed where can I find log files to help me identify the issue. IIS logs don't tell me anything. PHP or MySQL logs? I m having similar problems with Insert but I am assuming it is the same issue.

There wouldn't be any log files with errors... the issue was the code wasn't running at all because the trigger wasn't valid. If you open the insert or update server behavior and use the select list to choose the button press trigger associated with the form on the page it should generate the correct code.

I am doing what you are suggesting and still nothing is being added. I am noticing that my DW CS6 is haning on a regular basis where I have to delete the configuration directory.

What other thoughts should I be looking at? As it stands nothing is being added. PLEASE HELP

The code looks correct. If you give me a url where I can test and FTP access I can debug it for you. You may be able to debug it yourself by adding this below the update:

if ((((isset($_POST["AddVarietyButton"]))?$_POST["AddVarietyButton"]:"") != "")) {

  var_dump($InsertQuery);

  die();

}

That will write information about the insert including any error messages that should lead you to what is causing the insert to fail.

THANK YOU!!!!

After dumping the sql I found the error. There was an issue with my Auto-increment in my database. Took me all of 3 minutes to figure out once I read the output dump. Thread closed as fixed.