PaulCheung wrote:
I have been having real difficulties try to insert a 20 column record into a table (using PHP not MySQL monitor).
I'd echo the query before sending it to the db engine, copy and paste it into the query browser, and then see what happens. It seems as if you do not escape anything and if one of the POST values has some single quote or other objectionable character in it the query will not go through because of a syntax error. If that is the case, you hit the best case scenario of failure, because the worst case is SQL injection.
Since the only difference is the values that you get from $_POST I'f take a look at those and print_r the$_POST array for testing (or use a debugger for that).
David _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
