BetterPHP

All my code is in the top.

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


:/

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: ...

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 . What can I use instead?

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...