MYSQL Duplicating Issue
#4

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);
Reply


Messages In This Thread
MYSQL Duplicating Issue - by UnknownGamer - 07.01.2014, 21:36
Re: MYSQL Duplicating Issue - by sammp - 07.01.2014, 22:27
Re: MYSQL Duplicating Issue - by UnknownGamer - 07.01.2014, 22:55
Re: MYSQL Duplicating Issue - by ikey07 - 07.01.2014, 23:51
Re: MYSQL Duplicating Issue - by UnknownGamer - 08.01.2014, 20:34
Re: MYSQL Duplicating Issue - by sammp - 08.01.2014, 21:00

Forum Jump:


Users browsing this thread: 3 Guest(s)