[IceBilizard]

Hello guys today i have decided to work on MySQL so i have start to convert my saving system to MySQL but i got some problems with saving i have created a table users and when i try to add more then 5 columns then data not getting saved i am confused please help me.

this code working perfectly and saving data

PHP код:

format(query2 ,sizeof(query2), "INSERT INTO `users` (PN, PS, SC, MN, DT) VALUES ('%s', 'abc', %d, %d, %d)",
playername, GetPlayerScore(playerid), GetPlayerMoney(playerid), deaths[playerid]);
mysql_query(mysql, query2); 


if i add 1 more column then its not getting saved.

table structure

[jlalt]

it can be your query2 size try increasing it then adding another column.

[IceBilizard]

Quote:

Originally Posted by jlalt it can be your query2 size try increasing it then adding another column.

Thanks you man solved my problem

+REP

[itsCody]

If you're updating values that are already in the database, you just use..

Just an example

PHP код:

new query2[200];
mysql_format(mysql, query2 , sizeof(query2), "UPDATE `users` SET PS = 'abc', SC = '%d,' MN = '%d', DT = '%d' WHERE PN = '%e'", GetPlayerScore(playerid), GetPlayerMoney(playerid), deaths[playerid], playername); 
mysql_query(mysql, query2); 


If you don't want to use mysql_format use %q for strings to escape them.

Though many would recommend saving with their database ID, instead of their usernames