View Single Post
  #1 (permalink)  
Old October 7th, 2004, 10:32 AM
ss2003 ss2003 is offline
Authorized User
Points: 90, Level: 1
Points: 90, Level: 1 Points: 90, Level: 1 Points: 90, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2003
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default INSERT syntax error

Can anyone tell me whats wrong with my syntax? I have a php script that I am trying to use to upload data from a csv file into my table. I get this error when I run it:

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 'dec, catalog_num, constellation ) VALUES ( '23.23964', '-14.991

My SQL statement is:

mysql_query( "INSERT INTO test ( ra, dec, catalog_num, constellation ) VALUES ( '$ra', '$dec', '$catalog_num', '$constellation' )" ) or die( mysql_error());

thanks!

Reply With Quote