Cannot INSERT or UPDATE with the word 'from' anywhere

[nickd]

I have a Call log that uses php and html interface to keep track of people calling in for various reasons - if I try to put the word 'from' anywhere in one of the fields I get an internal error message 500, not sure why, but every other word I have tried works fine - just kinda stumbled across this.

Other tables in the same database can store the word 'from', and I'm not using it as a field name (reserved words)

Seems like a weird problem to troubleshoot, anyone have experience with this?

os: windows xp
Server version: 4.0.27-standard
UNIX socket
MySQL client version: 4.1.10

[ronverdonk]

No, never experienced this. Show your INSERT or UPDATE statement, so we can have a look and try to find some reason.

Ronald :cool:

[nickd]

[PHP]mysql_query("INSERT INTO `Call Log` VALUES ('$date', '$time','$tname','$me','$caller','$c_phone','$prob lem','$resolution','$status','$logger','$priority' ,'$property',NULL, '$vendor', '$address', '$city', '$state', '$zip')") or die(mysql_error()); [/PHP]

[PHP]mysql_query("UPDATE `Call Log` SET `date`='$date', `time`='$time',`t_name`='$tname',`t_index`='$tinde x',`caller`='$caller',`c_phone`='$c_phone',`proble m`='$problem',`resolution`='$resolution',`status`= '$status',`logger`='$logger',`priority`='$priority ',`property`='$property', `vendor`='$vendor', `address`='$address', `city`='$city', `state`='$state',`zip`='$zip' WHERE `index` = '$index' LIMIT 1") or die("Oops".mysql_error()); [/PHP]

[ronverdonk]

The only thing left could be that you store a char value in a numeric type field and the char value happens to be 'from'. Do you know the column on which the error occurs?

Ronald :cool:

[nickd]

normally the difficulty is in the 'problem' or 'resolution' columns since these are html text areas where I can enter a large (more than 255) amount of text (text is the data type of the column - wonder if that is a problem), but I can also try and enter the word 'from' in phpmyadmin and the problem continues - ok here's the error from php myadmin when I try and INSERT anything, it actually does INSERT (when I browse the table), but comes up with this error message

Error
SQL query:

INSERT INTO (

)
VALUES (
), (
)

MySQL said:

#1064 - 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 '() VALUES (), ()' at line 1

This is a very minor problem, and probably has something to do with the way I structured the table, I'll try and make a new table with similar columns and debug the data types - see if I can narrow it down more... thanks for helping

[ronverdonk]

What worries me is the part of the statement that says

VALUES (
), (
) 

an INSERT has the following format usually

INSERT INTO table (col1, col2, ....coln) VALUES(val1, val2, .... valn);

So I wonder what bthe extra comma and parentheses are doing after the VALUES specification. Can you show us?

Ronald :cool:

[nickd]

yeah, that is weird, that error message generated after using phpmyadmin to INSERT anything into the table, and I can't reproduce that error on another table in phpmyadmin.

I didn't know that you should specify columns before specifying values in the insert method - i'll try putting that in the code