jatar_k - 4:49 pm on Aug 4, 2013 (gmt 0)
is it field1 that is giving the error? what is the exact error?
I do find it much easier when I build my queries separate from the mysql_query call, like so
$q = "INSERT INTO $tablename values ('', '$field1', '$field2', '$field3', '$field4')";
$insert = mysql_query($q);
then I can echo the exact thing I am sending and paste that into the command line or phpmyadmin, or whatever you use for mysql, and look at the precise error.
you also should use only single quotes inside your qeury and double around, makes things easier