Hallo mensen,
Ik heb een query
PHP
mysql_query("INSERT INTO
message
(date,
ip,
from,
to,
subject,
msg,
removed,
read)
VALUES
('" . time() . "',
'" . $_SERVER['REMOTE_ADDR'] . "',
'" . strtolower($data['nickname']) . "',
'" . strtolower($_POST['to']) . "',
'" . addslashes($_POST['subject']) . "',
'" . addslashes(htmlentities($_POST['msg'])) . "',
'no',
'no')") or die(mysql_error());
Toon Meer
Alleen hij geeft een mysql_error aan:
PHP
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 'from, to, subject, '
Dit is de message tabel.
PHP
CREATE TABLE IF NOT EXISTS `message` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`date` int(10) NOT NULL,
`ip` varchar(32) NOT NULL,
`from` varchar(16) NOT NULL,
`to` varchar(16) NOT NULL,
`subject` varchar(100) NOT NULL,
`msg` text NOT NULL,
`removed` varchar(5) NOT NULL,
`read` varchar(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Toon Meer
Wat doe ik fout?