I run the code I created and I get this error below.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character, tag, server, type, outfit, url, voice) VALUES ('test','test','test','' at line 1
Below is the code I use
<?
require_once("funcs.inc");
$character = ($_POST['character']);
$tag = ($_POST['tag']);
$server = ($_POST['server']);
$type = ($_POST['type']);
$outfit = ($_POST['outfit']);
$url = ($_POST['url']);
$voice = ($_POST['voice']);
$fields = "(character, tag, server, type, outfit, url, voice)";
$values = "('$character','$tag','$server','$type','$outfit','$url','$voice')";
$query2 = "INSERT INTO `users` $fields VALUES $values";
$result2 = dbquery($query2);
if (!$result2)
{
print ("Submit Failed!");
die;
}
else
{
print ("Insert Successfully!");
?>
<meta http-equiv="refresh" content="">
<?
}
?>