ik kan fout in query niet vinden

[Barry_127]

hoi,

ik krijg deze fout als ik mijn script uitvoer:
You have an error in your SQL syntax near 'to='1', from='1', date='21-11-2004, 14:57', subject='aa', mssg='aa :S '' at line 1

dit is mijn database tabel:

CREATE TABLE `pms` (
  `pmid` int(255) NOT NULL auto_increment,
  `to` int(30) NOT NULL default '0',
  `from` int(30) NOT NULL default '0',
  `date` varchar(17) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `mssg` text NOT NULL,
  PRIMARY KEY  (`pmid`)
) TYPE=MyISAM

en dit is mijn query:

<?php
$query = "INSERT INTO pms SET to='" . $to . "', from='" . $usrid . "', date='" . $date . "', subject='" . $subject . "', mssg='" . $mssg . "'";
?>

ziet iemand misschien wat er fout is?

 

[JPeetje]

$query = "INSERT INTO pms (pmid,to,from,date,subject,mssg) VALUES ('','" . $to . "','" . $usrid . "','" . $date . "','" . $subject . "','" . $mssg . "'";

Succes :thumb:

 

[Barry_127]

Geplaatst door JPeetje

$query = "INSERT INTO pms (pmid,to,from,date,subject,mssg) VALUES ('','" . $to . "','" . $usrid . "','" . $date . "','" . $subject . "','" . $mssg . "'";

Succes :thumb:

na dit letterlijk hgekopieerd te hebben krijg ik nog steeds een fout:

You have an error in your SQL syntax near 'to,from,date,subject,mssg) VALUES ('','1','1','21-11-2004, 16:31','blaat','aaa'' at line 1

 

[JPeetje]

$query = "INSERT INTO pms (pmid,to,from,date,subject,mssg) VALUES ('','" . $to . "','" . $usrid . "','" . $date . "','" . $subject . "','" . $mssg . "')";

Haakje vergeten
Probeer 't nu nog eens ?

 

[Barry_127]

bedank!

ik moest alleen nog wel even van de kolommen `kolommen` maken (met haakjes)

status => opgelost