For some reason, my code goes directly to “Error” I’m not really sure why. I test my SQL connection, no issues. The information on the tables is there. Maybe you can spot what I’ve done incorrectly?
[php]
$otoon = mysql_real_escape_string($_POST[‘otoon’]);
$oserver = mysql_real_escape_string($_POST[‘oserver’]);
$server = mysql_real_escape_string($_POST[‘server’]);
$sql=“UPDATE regusers_test
INNER JOIN alt_toon ON (alt_toon_test.toonname = regusers_test.toonname)
SET server=’$server’
WHERE username=’$user’ AND server=’$oserver’ AND toonname=’$otoon’”;
if (!empty($server)) {
if (mysql_query($sql,$con))
{
echo "Server updated to: " . $server;
} else {
echo “
Error
”;}
mysql_close($con);
[/php]