UPDATE not Updating... (PHP & MySQL)

[Hojo]

I am trying out PHP for the first time and having a fairly easy time figuring things out for myself, but this is stumping me. May be the simplest solution, but my brain is not seeing it.

When I run the following script, everything seems to work, but my database record does not update.

<?php

print "<p>Saving Changes...</p>\n";

Include( "connect_mysql.php" ); // Connects with no problem

$query = "UPDATE home_text SET headline = '$_POST[new_head]', body = '$_POST[new_body]' WHERE id = '$_POST[id]'"; // All values are present as I had been printing them out to check previously

printf ("Records Updated: %d\n", mysql_affected_rows()); // Verifies that 1 record has updated every time

print "<p>Changes Saved...</p>\n";

print "<p><a href=admin_home.php>Back to Admin page</a></p>\n";

?>

When I look using MySQL Control Center nothing has changed. Why would this be... A nomination for a Nobel Peace Prize to the person who can tell me where I am falling down here....

Thanks
Hojo

[designguy79]

You need to actually send the query to MySQL. Also, it would be a good idea to check for any errors.

$result = mysql_query($query);
if (!$result) {
   die('Invalid query: ' . mysql_error());
}

Hope that helps!

[Hojo]

Helps... It's the whole problem... A definite 'couldn't see the forest for the trees' situation.

The Nobel Peace Prize nomination is yours! Look for email from Sweden... :-)

Thanks
Hojo