Sql Syntax

[SpyShadow]

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="">
<?
}
?>

Edited December 18, 2012 by SpyShadow

[Pikachu2000]

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

[SpyShadow]

ok so how should the fields, values and query should look?

[Pikachu2000]

Reserved words, if you chose to use them as field/table identifiers, should be in `backticks` in the query string. You'd probably be best to simply rename the field/table to something that isn't a reserved word, though.

[SpyShadow]

ok, I will rename any reserved words to something else. I did not know that some words won't work for columns or values.

 

 

EDIT: Got it to work now. Learn something new everyday. Thanks for the help.

Edited December 18, 2012 by SpyShadow