Basic UPDATE MySQL not working for me...

[suttercain]

Good afternoon,

 

I thought I would have this but after repeated attempts I can't get it.

 

I am trying to update a record but it doesn't want to take.

 

<?php error_reporting(E_ALL); ?>
<?php

require ('get_connected.php');
if (isset($_GET['id'])) {
$record_id = $_GET['id'];
$letter_sent = date('F jS, Y');
    $sql = "UPDATE canada SET letter_sent='" . $letter_sent . "' WHERE record_id='" . $record_id . "'";
echo "<a href='admin_canada.php>Go Back to the Admin Panel</a>";
       
  } else {
  echo " Something Went Wrong!"; }
?>

 

I echoed both $record_id and $letter_sent to verify they were set and they both worked.

 

Is something wrong with my UPDATE line?

[ataria]

Nothing is wrong with your line, your just not running a query.

 

$update = mysql_query($sql) or die(mysql_error());

 

Put that line below $sql.