Parse error: parse error, unexpected T_ELSE in ... on line 18

[rageinmypjs]

After a bit of pulling on what little hair I have left I figured I might have someone see if they might see the error 🙂 This is a function that is called when a form is submitted.

<?php
function InsertChar()
{
$query="INSERT INTO Characters
(CharacterName,Nature,CreateDate,Species,Sanctioned) VALUES
(\"$POST[CharacterName]\",\"$POST[Nature]\",NOW(),\"Test\",\"No\")";

// echo("query=$query");
$result=mysql_query($query)
// or die ("Could not execute query");
or die ("Could not execute query.<br>".mysql_error()."<br>");
echo "Character Submitted.<br>";
}
else { echo "Character "\$_POST[CharacterName]\" has been placed in the database";
}
}
?>

[Drakla]

Your string escaping is all shot to hell, plus what's this else in a function without an if

function InsertChar()
{
	$query = "INSERT INTO Characters (CharacterName,Nature,CreateDate,Species,Sanctioned) VALUES
	('$_POST[CharacterName]', '$_POST[Nature]', NOW(), 'Test', 'No')";

$result = mysql_query($query) or die ("Could not execute query.<br>".mysql_error()."<br>");

echo "Character Submitted.<br>";

echo "Character '$_POST[CharacterName]' has been placed in the database";
}

[rageinmypjs]

Originally posted by Drakla
Your string escaping is all shot to hell, plus what's this else in a function without an if

function InsertChar()
{
	$query = "INSERT INTO Characters (CharacterName,Nature,CreateDate,Species,Sanctioned) VALUES
	('$_POST[CharacterName]', '$_POST[Nature]', NOW(), 'Test', 'No')";

$result = mysql_query($query) or die ("Could not execute query.<br>".mysql_error()."<br>");

echo "Character Submitted.<br>";

echo "Character '$_POST[CharacterName]' has been placed in the database";
}

[/B]

I looked at that too as being unneeded. I am not sure what you mean exactly by the string escaping.