mysql error - hvad er der galt her?
jeg får følgende fejl:You have an error in your SQL syntax near 'key='#000000' WHERE id='1'' at line 1
-jeg kan altså ikke finde min fejl :(
Alle de forskellige keyXX-værdier er fra form-input felter, og indeholder en html hex-farve.
-----savesettings.php-----
<?
include("database.php");
$key1 =addslashes($key1);
$key2 =addslashes($key2);
$key3 =addslashes($key3);
$key4 =addslashes($key4);
$key5 =addslashes($key5);
$key6 =addslashes($key6);
$key7 =addslashes($key7);
$key8 =addslashes($key8);
$key9 =addslashes($key9);
$key10=addslashes($key10);
$key11=addslashes($key11);
$key12=addslashes($key12);
$key18=addslashes($key18);
$key24=addslashes($key24);
$key25=addslashes($key25);
$key26=addslashes($key26);
$key27=addslashes($key27);
$key28=addslashes($key28);
$key29=addslashes($key29);
$key30=addslashes($key30);
$key32=addslashes($key32);
$key33=addslashes($key33);
$key34=addslashes($key34);
$key35=addslashes($key35);
$key36=addslashes($key36);
$key37=addslashes($key37);
$key38=addslashes($key38);
mysql_query("UPDATE misc_shoutbox1_config SET key='$key1' WHERE id='1'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key2' WHERE id='2'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key3' WHERE id='3'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key4' WHERE id='4'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key5' WHERE id='5'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key6' WHERE id='6'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key7' WHERE id='7'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key8' WHERE id='8'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key9' WHERE id='9'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key10' WHERE id='10'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key11' WHERE id='11'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key12' WHERE id='12'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key18' WHERE id='18'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key24' WHERE id='24'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key25' WHERE id='25'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key26' WHERE id='26'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key27' WHERE id='27'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key28' WHERE id='28'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key29' WHERE id='29'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key30' WHERE id='30'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key32' WHERE id='32'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key33' WHERE id='33'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key34' WHERE id='34'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key35' WHERE id='35'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key36' WHERE id='36'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key37' WHERE id='37'")or die(mysql_error());
mysql_query("UPDATE misc_shoutbox1_config SET key='$key38' WHERE id='38'")or die(mysql_error());
header ("Location: index.php");
?>
-----savesettings.php-----
