ok here we go. I am attempting to insert some information into a database.(php 101 all over again)
here is the code
$sql = mysql_query("INSERT INTO chat (first_name, last_name, email, department, status, chat_date, chat_time, chat_text, from) VALUES ('$first_name', '$last_name', '$email', '$department', '$status', now(), now(), '$chat_text', '$from')") or die(mysql_error());
This is the mysql error that I get.
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 'from) VALUES ('testguy', 'test', 'firstname.lastname@example.org', 'Support', 'waiting'' at line 1
I am sure that this is a simple error but it is hanging me up. When I erase from from the query, it inserts just fine.
Any suggestions would be great.