PHP MySQL Script Error?

Question

I have the following PHP code that I can't seem to get working. I have looked over and over again for the error(s), but can't find it/them.

<?php
$actkey = rand() . "\n";
$con = mysql_connect("HOST", "USER", "PASS");
if (!$con)
  {
  die('Unable to connect:  ' . mysql_error());
  }

mysql_select_db("TABLE", $con);

mysql_query("UPDATE members SET Activation = $actkey WHERE username = 'admin'");
mysql_close($con)

$con2 = mysql_connect("HOST" , "USER" , "PASS");
if (!$con2)
  {
  die('Unable to connect:  ' . mysql_error());
  }
mysql_select_db("a1719745_insaneb", $con2);
$query = mysql_query("INSERT INTO Activation (keycode, valid) VALUES ($actkey, 'yes')");
if(!mysql_query($query, $con2)) {
  die('Error:  ' . mysql_error());
}
mysql_close($con2);
echo "Complete";
?>

Any ideas?

Answer 1

There's a missing semicolon after mysql_close($con).