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!

Echo the processed query and post it here please.

$query = "INSERT INTO test ( ra, dec, catalog_num, constellation ) VALUES ( '$ra', '$dec', '$catalog_num', '$constellation' )";

echo $query;

Please tell me what it says.

-Snib <><
http://www.snibworks.com
There are only two stupid questions: the one you don't ask, and the one you ask more than once ;)