Having problems with inserting data in right column with jquery and PHP

[therocker]

I'm not really sure were this belongs because I don't really know which part of my script is causing the problem.

So I have screen printed my issue. I think screen printing and showing you guys what my problems are is a great idea rather then me trying to explain myself. Pictures show more than words. But anyways.

 

My main problem is that I want to insert the data "privacy=everyone" into it's own separate column, but also take the "privacy" out and insert into the column with the data "everyone". This is what I got so far.

 

This is my issue I have on a live page. I cropped everything out except the issue.

 

Here is my PHP code.

 

Here is my Jquery code.

 

And here is my MySQL data.

 

My ideal MySQL data would look something like this.

 

If I forgot something, I'll edit this post.

 

EDIT: I should also mention that some of the PHP codes are whiten out in case of coping. The status and category are suppose to be one, but I had whiten out the other codes so the category and status looks like they're not aligned, but they are in my real code.

Edited December 17, 2013 by therocker

[mac_gyver]

your data: parameter needs to be two separate keys/values, not just one string for the first parameter. i would copy/paste your code showing how, but since it's an image, cannot do that. please just post text in the future.

 

it should look like this - data: { name: "John", location: "Boston" }

[therocker]

your data: parameter needs to be two separate keys/values, not just one string for the first parameter. i would copy/paste your code showing how, but since it's an image, cannot do that. please just post text in the future.

 

it should look like this - data: { name: "John", location: "Boston" }

Thanks. It works now. Sorry for using images. I'll use images for the results and text for the codes.