php and mysql wierd error
Posted: Wed Jan 03, 2007 4:39 pm
I've looked up the error and checked my code 100 times and I still cant find anything to change.... any ideas?
Here's my code:
Echo'd $sqla:
Error:
Here's my code:
Code: Select all
$sqla="INSERT INTO `mail` (to, from, title, text, time, seen, type) VALUES ('$cname', '$rlname', '$name2', '$name', $time, 1, 'mail')";
$resulta=mysql_query($sqla) or die(mysql_error());Code: Select all
INSERT INTO `mail` (to, from, title, text, time, seen, type) VALUES ('userx', 'userb', 'test', 'test', 1167863902, 1, 'mail')You have an error in your SQL syntax; check the manual that corresponds to yo
ur MySQL server version for the right syntax to use near 'to, from, title, text, time, seen, type) VALUES ('userx', 'userb', 'test', ' at line 1