Jump to content

Archived

This topic is now archived and is closed to further replies.

Tyco

Insert Issues

Recommended Posts

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', 'Frank@domain.com')' at line 1
[/code]

Any ideas.... Thanks!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.