Entry

INSERT statements via mysql_query() fail to add records to the database. How to troubleshoot?

Oct 18th, 2001 14:24
Narendra Jain, Nicholas Hadaway,

The best way to do this is to echo the sql statement just before you
execute the query. Then, have another window open where you start up a
session of mysql. Copy and paste the query from the echo screen to the
mysql screen and see what exact error is returned by mysql.
Other way is to use the query result feature and display what exact
error was returned by mysql.
Hope that helps...
Narendra Jain