"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

There may be some errors in the script that are not visualized, so you would never know they are happening. You want to add error_reporting(E_ALL) to the top of your PHP scripts to help catch these "silent errors."

You may also find that var_dump() is your friend when you do not know exactly what a function returns or what a data element contains! For example, you might want to create the query string in its own variable and print it with var_dump() so you can see exactly what is getting sent to the SQL engine.

Here's a quick look at $_POST['data']. Looks like each element consists of an array with a name like "COL_xxx" at position zero, and an array at position one. This interior array has a collection of "ID_xxx" data elements, with position zero being empty in every case. Is this what you expect from the AJAX request?

1. Please add a test for query success or failure (MySQL and MySQLi both have return values from the _query() method) and visualize the error messages if any. Please error_log() those messages and post them here.

2. Be sure that you're running the correct scripts during the test - you can add some identifying information to the error_log() statements.

3. Show us the CREATE TABLE statements for the "jobs" table.

4. Show us the code in this: include('connection.php'); -- you can obscure any passwords, etc., but we need to see if the DB connection is being made correctly in the AJAX script.

0

Karen LiddyOffice ManagerAuthor Commented: 2016-10-10

I will post the information you requested shortly (not home or work atm). However the log.txt gets the information correctly so the information is being sent to the save_order page and the function seems to be working, just my update statement. Connection page makes connection ok as prevous page jobs can list all the information.