[RESOLVED] MySQL Error

[spiritssight]

Hello All,

I got to say I am moving right along with my script and now I am getting this error:

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 ') VALUES ('', '', '061429758', '5880', 'DELTA SIGMA PHI FRATERNITY INC ' at line 1

Code that gives error:

$query = "
       INSERT INTO tbl_entity_info (e_id, e_pid, fin, gen, pno, sn, s_c, cc, ntee, a_c, oc, fc, ac,)
       VALUES ('$e_id', '$e_pid', '$fin', '$gen', '$pno', '$sn', '$s_c', '$cc', '$ntee', '$a_c', '$oc', '$fc', '$ac')";
$result = mysql_query($query) OR die("Was unable insert ".$fin." into the database table Entity Info! <br />" . mysql_error());

Now I don't get this error with the following query thats setup the same but this has less fields

Code that gives no error:

$query = "INSERT INTO allow (fin, date_allowed, who_allowed) VALUES ('$fin', NULL, 'p-131498798')";
$result = mysql_query($query) OR die("Was unable insert ".$fin." into the database table Allowed! <br />" . mysql_error());

echo "". $fin ." has been added to the Accepted list! <br />";

What am I doing wrong that I don't see and have been playing with now for over 2 hours?

Thanks very much!

Sincerely,
Christopher

[laserlight]

I would guess that you have an extra comma at "ac,)".

[spiritssight]

Thanks very much it now works, I did not even think about looking in that area, I forgot no , at the end of the () things :-)

Thanks again,
Christopher

[bradgrafelman]

Don't forget to mark this thread resolved.