Search found 5 matches

by scdogas321
Sat Jun 29, 2013 5:35 pm
Forum: Tutorials
Topic: Private Message System Pt. [08]. Can't insert messages...
Replies: 8
Views: 1993

Re: Private Message System Pt. [08]. Can't insert messages..

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 ' DATETIME, 'test')' at line 2


:/
by scdogas321
Sat Jun 29, 2013 2:56 pm
Forum: Tutorials
Topic: Private Message System Pt. [08]. Can't insert messages...
Replies: 8
Views: 1993

Re: Private Message System Pt. [08]. Can't insert messages..

So, I've done like this: [syntax=php] $conversation_id = mysql_insert_id(); $theTime = time(); $sql = "INSERT INTO conversations_messages ( conversation_id, user_id, message_date, message_text) VALUES ({$conversation_id}, {$_SESSION['id']}, {$theTime}, '{$body}')"; [/syntax] and it' says: ...
by scdogas321
Sat Jun 29, 2013 1:57 pm
Forum: Tutorials
Topic: Private Message System Pt. [08]. Can't insert messages...
Replies: 8
Views: 1993

Re: Private Message System Pt. [08]. Can't insert messages..

Well I get this error:

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 ' UNIX_TIMESTAMP(), 'werwe')' at line 2

I think that UNIX_TIMESTAMP is a little bit out of date :D. What can I use instead?
by scdogas321
Sat Jun 29, 2013 11:04 am
Forum: Tutorials
Topic: Private Message System Pt. [08]. Can't insert messages...
Replies: 8
Views: 1993

Private Message System Pt. [08]. Can't insert messages...

Well hello everyone , I have this title problem. So when I type the message and press send then look in my database and conversations table is filled, conversations_members is filled, but conversations_message is empty :/. Can anyone help me? Here's the code: [syntax=php] require("./connect.php...