INSERT error

ajna

I am going nuts over this -- maybe I have been "too close" to this code and just can't see what's basic in front of my eyes.

I am having an INSERT problem that SEEMS to be caused by an apostrophe/single quote. But I AM addslahing the text string, so it should be ok....right? RIGHT?!?! Always worked before...

INSERT INTO Mailbox (UserID, SenderID, Message_Date, Subject, Message_Text, Unread, Notified, Canned) VALUES ('2', '1', '2001-08-14 03:09:37', 'NO SUBJECT', 'This is a test\'s of test', '0', '1', '0');

TABLE INFO:

MessageID is auto_increment

FIELD TYPE NULL DEFAULT
MessageID int(11) No

UserID int(11) No 0

SenderID int(11) No 0

Message_Date datetime No 0000-00-00 00:00:00

Subject varchar(100) No

Message_Text text No

Unread tinyint(4) No 1

Notified tinyint(4) No 0

Canned tinyint(4)

Any ideas? This supposedly straight-forward bit of coding has had me on the ropes for hours. I kid you not...

Kev

juschillinnow

can you post your whole query code?

and what's the error? any error number or anything?

ajna

Data for variables is listed above with the exception of $MATTER which has no slash in it until the addslashes function.

$MATTER = addslashes($MATTER);

$sql5 = "INSERT INTO Mailbox (UserID, SenderID, Message_Date, Subject, Message_Text, Unread, Notified, Canned) VALUES ('$ToUserID', '$FromUserID', '$TIMEY', 'NO SUBJECT', '$MATTER', '$Unread', '1', '0')";

@($sql4,$connection) or die(mysql_error());

The error is, get this: Query was empty.

Man, I can just feel that I am missing something basic. Like when you forget a semi-colon in 400+ lines of code.

ajna

man..wait...$sql4?!?!?
hold on

juschillinnow

😉 that should do it I think.

ajna

Thanks for asking me to post that code.......I found the problem. Telling the system actually process the right query would have helped a lot!

Geez...been staring at code too long today.

Thanks!

Kev