Inline Ajax Editor and MySQL

[whobutsb]

Hi Guys
I'm working on a spreadsheet like web application using a bit of PHP, Ajax and MySQL. I have a spreadsheet that is reading off of a MySQL database.

Then I'am using this simple AJAX inline editor to edit the values in the spreadsheet and post them back up to the server. I can get the values to stay within the spreadsheet but they won't post up to the database.

There is an accompanying update.php file that is executed after the values on the spreadsheet have been updated. Here is my code:

<?php
$content = $_GET['content'];
$fieldname = $_GET['fieldname'];
echo stripslashes(strip_tags($_GET['content'],"<br><p><img><a><br /><strong><em>"));

$update1 = "INSERT INTO paceReport `$fieldname` VALUES $content";
$result = mysql_query($update1)
    or die;

?>

Am I missing something in my code? Should I be using an UPDATE query instead of a INSERT query? Your help is greatly appreciated.
Thanks!

[Kudose]

Your not actually running the query. Just assigning it to $result.

[ClarkF1]

It is running the query, try having some output in the die statement e.g.

Try

$update1 = "INSERT INTO paceReport (`$fieldname`) VALUES ('$content')"; 
mysql_query($update1) or die('Error: '.mysql_error());

You don't really need to assign it to $result as it doesn't retrieve any information for you to display and any errors will be thrown up by the die() statement.

If you're editing stuff already in the database you need to use UPDATE rather than INSERT which will add a new row