Code: Select all
q("INSERT INTO dt_messages (sid, rid, subject, message, timesent) VALUES (".$fMemberїid].", $rid, '$subject', '$message', ".(strtotime(date("d M Y H:i:s"))).")");What does the "q" stand for?
"INSERT INTO dt_message" is calling the table.
(sid, rid, subject, message, timesent) is the table column names. What do you think sid and rid stand for?
VALUES (".$fMember[id].", $rid, '$subject', '$message', ".(strtotime(date("d M Y H:i:s"))).")"); are variables collecting values from a form.
Now I changed to code (to below) to simply add a fixed subject and message but it did not insert anything into the database. Please tell me what I did wrong?
Code: Select all
VALUES (".$fMemberїid].", $rid, 'Virtual Kiss', 'You have been Virtual Kissed', ".(strtotime(date("d M Y H:i:s"))).")");