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("I开发者_运维问答NSERT INTO Activation (keycode, valid) VALUES ($actkey, 'yes')");
if(!mysql_query($query, $con2)) {
die('Error: ' . mysql_error());
}
mysql_close($con2);
echo "Complete";
?>
Any ideas?
There's a missing semicolon after mysql_close($con)
.
精彩评论