07.01.2014, 23:51
My suggestion is set default values for each field in the database, and in the script, use INSERT INTO only for values which are different than default.
But your whole query looks abit akward, use this kind of query:
mysql_query("INSERT INTO `table` (`stat1`,`stat2`,`stat3`,`stat4`) VALUES ('%s','%d','%d','%f');",stat1,stat2,stat3,stat4);
But your whole query looks abit akward, use this kind of query:
mysql_query("INSERT INTO `table` (`stat1`,`stat2`,`stat3`,`stat4`) VALUES ('%s','%d','%d','%f');",stat1,stat2,stat3,stat4);