what's wrong in this query?

[SoulFly]

$query_insert = "INSERT INTO posts(subject,post,userid,catid) VALUES('$subject','$post',1,$catid,'$idate')";
mysql_query($query_insert) or die("wrong query!!!");

[cjliu42]

Too many values???

[SoulFly]

no way! i also tried to insert less values but it didn't matter. does any body have another idea?

[cjliu42]

You have too many values for the specified number of fields

should be something like:-

INSERT INTO table (join_id, user_id, date_joined)
VALUES (1, '[e-mail]','2001-10-02');

[SoulFly]

hoo know i understand what you had ment before! great and thank you a lot. However, i tried this query and it displayed me an error message again :

$query_insert = "INSERT INTO posts(subject,post,userid,catid,date) VALUES ('$subject','$post',1,$catid,'$idate')";
mysql_query($query_insert) or die("wrong query!!!");

[Lars_Berg]

Get the real error message.

$query_insert = "INSERT INTO posts(subject,post,userid,catid,date) VALUES ('$subject','$post',1,$catid,'$idate')"; 
mysql_query($query_insert) or die(mysql_error());

[Mystikal]

Make sure that addslashes() has been put on these variables that could contain ' characters. try printing the query and executing it in phpMyAdmin.

If it already has the slashes (some installations do that) don't use addslashes.. but it sounds like that is the problem.