The "datum" column

"datum" is a unix date/time stamp (seconds from 1.1.1970).

Thanks Slabbi, I do realize what it is, but I can't figure out for the life of me how to use it in my SQL statement. From what I can assume from the FAQ, is that I have to include something in the place of: (timestamp now). I've tried adding quotes ('') around it, taking out the parentheses ( & ), I've tried 'time()' with & without quotes.

Timestamp should just be a fixed figure (whatever the current time right now is), so all I need to know is what the syntax in php/Joomla/mySQL for uddeIM is, and if anyone could help me with that, I'd really appreciate it.

$sql = "INSERT INTO jos_uddeim (fromid, toid, message, datum) VALUES (".(int)$uid.", 84, ".$message.", ".(int)time().")";

Ensure that all text strings are "clean", so no SQL injection is possible.

Post edited by: slabbi, at: 2009/03/12 10:03

hmm, never would've guessed that. In all the programming sites I like, they don't talk about that.
Thank you for your help.