Tyco Posted March 23, 2006 Share Posted March 23, 2006 Well, I have never had this problem and I just cant figuer out what I did wrong. I copied some files to a home-server for dev testing and I had this script running on my hosted server. But, after making some mods and much to the script I could not pass this step. I also dont remember what changes I made. Anyways heres the problem. I have this code: [code]if(mysql_num_rows($result) == 0){mysql_query("INSERT INTO table (name, date, type, email) VALUES('$name', '$time', '$type', '$email') ")or die(mysql_error());}[/code]But then I get this error:[code]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 'date, type, email) VALUES('Frank', 'March 22', 'on', '[email protected]')' at line 1[/code]Any ideas.... Thanks! Link to comment https://forums.phpfreaks.com/topic/5553-insert-issues/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.