script not updating db

[atsphpflash]

Hello,

I'm using a form to update info in the db. When user submits form, I want the data to be updated in the database, and I want the updated content to appear on form's action page. If I submit, I can get the content to appear in the page, but I can't get the db to update. Any ideas what I'm messing up here?

<?php
include("../php_includes/settings.inc.php");
$connect = mysql_connect ($hostname, $username, $password);

if (isset($POST['content'])) {
$codeContent = $POST['content'];

$codeContent = str_replace('<TEXTFORMAT LEADING=\"2\">', "", $codeContent);
$codeContent = str_replace('</TEXTFORMAT>', "", $codeContent);
$codeContent = str_replace("_sans", "sans-serif", $codeContent);
$codeContent = str_replace('SIZE=\"9\"', "SIZE=\"1\"", $codeContent);
$codeContent = str_replace('SIZE=\"12\"', "SIZE=\"2\"", $codeContent);
$codeContent = str_replace('SIZE=\"14\"', "SIZE=\"3\"", $codeContent);
$codeContent = str_replace('SIZE=\"16\"', "SIZE=\"4\"", $codeContent);
$codeContent = str_replace('SIZE=\"18\"', "SIZE=\"5\"", $codeContent);
$codeContent = str_replace('SIZE=\"22\"', "SIZE=\"6\"", $codeContent);
$codeContent = str_replace('>', ">\n", $codeContent);
$codeContent = str_replace('<', "\n<", $codeContent);
$codeContent = str_replace('&apos;', "'", $codeContent);

echo stripslashes($codeContent);

$sql = "UPDATE content1 SET content1_1='$codeContent' WHERE id='1'";
$result = mysql_db_query($database,$sql,$connect);

}

//Error Checking

if (mysql_db_query ($database, $sql, $connect)) {
/ Let's replace this line with an HTML page, or send the form to itself /
print ("Great, you've completed Step #2. You can see your updated content below. You're almost done. Now it's time to choose your music and images.");

}

else {

print ("Sorry, information not updated.  Contact Webmaster.");

}

mysql_close($connect);
?>

[kevinsequeira]

check this out

http://ca3.php.net/manual/en/function.mysql-affected-rows.php

also if id is numeric then ure update statement should be

 $sql = "UPDATE content1 SET content1_1='".$codeContent."' WHERE id=1"; 

ie no ' '

reg
kevin

[atsphpflash]

Well, that didn't change anything for me. It's still not updating.

What else could be wrong?

[kevinsequeira]

echo query;

see what the query actually is, run it directly in ure db

also why do u have this bit ?

if (mysql_db_query ($database, $sql, $connect)) {
/ Let's replace this line with an HTML page, or send the form to itself /
print ("Great, you've completed Step #2. You can see your updated content below. You're almost done. Now it's time to choose your music and images.");

}

else {

print ("Sorry, information not updated. Contact Webmaster.");

}

reg
kevin

[atsphpflash]

Kevin

The query works fine...I'm actually using the same query somewhere else.

As for the error checking...just for testing, to see if it is working.

[kevinsequeira]

well ure error checking bit is wrong cause its outside the if-else loop of the isset($_POST['content']

so ure $sql is always blank.
do this instead

<?php
include("../php_includes/settings.inc.php");
$connect = mysql_connect ($hostname, $username, $password);

if (isset($_POST['content'])) {
  $codeContent = $_POST['content'];

  $codeContent = str_replace('<TEXTFORMAT LEADING=\"2\">', "", $codeContent);
  $codeContent = str_replace('</TEXTFORMAT>', "", $codeContent);
  $codeContent = str_replace("_sans", "sans-serif", $codeContent);
  $codeContent = str_replace('SIZE=\"9\"', "SIZE=\"1\"", $codeContent);
  $codeContent = str_replace('SIZE=\"12\"', "SIZE=\"2\"", $codeContent);
  $codeContent = str_replace('SIZE=\"14\"', "SIZE=\"3\"", $codeContent);
  $codeContent = str_replace('SIZE=\"16\"', "SIZE=\"4\"", $codeContent);
  $codeContent = str_replace('SIZE=\"18\"', "SIZE=\"5\"", $codeContent);
  $codeContent = str_replace('SIZE=\"22\"', "SIZE=\"6\"", $codeContent);
  $codeContent = str_replace('>', ">\n", $codeContent);
  $codeContent = str_replace('<', "\n<", $codeContent);
  $codeContent = str_replace(''', "'", $codeContent);

  echo stripslashes($codeContent);

  $sql = "UPDATE content1 SET content1_1='$codeContent' WHERE id='1'";
  $result = mysql_db_query($database,$sql,$connect);
  if(!mysql_error()){
  	echo "database updated";
			echo "no of affected rows is ".mysql_affected_rows();

  }else{
  	echo "databse not updated";
  }	
}

mysql_affected_rows can be zero if the value remains unchanged
reg
kevin