Recover a value[mysql]
#10

Thank you for this, Im gonna try this

Is it possible to save something then load it just after or it needs something between to save ?

Thank you !



EDIT:

I did this:

Код:
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `joueurs` WHERE `posX` = '%f', `posY` = '%f' AND `posZ` = '%f' WHERE `Name` = '%s'  ", pInfo[playerid][posX], pInfo[playerid][posY], pInfo[playerid][posZ],  Name[playerid]);
mysql_tquery(mysql, query, "", "");
printf("\n %s", query); // printing to make sure the co-ords are being sent. );
But it still doesn't work...

This is what I want:
I save in the database informations, then I load them to use them after.

Код:
mysql_format(mysql, query, sizeof(query), "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Argent`, `posX` ,`posY`, `posZ`, `Interieur`, `World`, `Skin`, `Niveau`) VALUES ('%e', '%s', '%s', 0, 0, 1000, 1527.5634, -1738.9218, 13.5469, 0, 0, 26, 1)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
mysql_tquery(mysql, query, "", "");

mysql_format(mysql, query, sizeof(query), "SELECT * FROM `joueurs` WHERE `posX` = '%f', `posY` = '%f' AND `posZ` = '%f' WHERE `Name` = '%s'  ", pInfo[playerid][posX], pInfo[playerid][posY], pInfo[playerid][posZ],  Name[playerid]);
mysql_tquery(mysql, query, "", "");
printf("\n %s", query); // printing to make sure the co-ords are being sent. );



I can see that there's an error but I don't know how to solve it.

You got an idea please ?
Reply


Messages In This Thread
Recover a value[mysql] - by anou1 - 13.01.2014, 17:24
Re: Recover a value[mysql] - by maddinat0r - 13.01.2014, 17:42
Re : Recover a value[mysql] - by anou1 - 13.01.2014, 17:56
Re: Recover a value[mysql] - by maddinat0r - 13.01.2014, 18:10
Re : Recover a value[mysql] - by anou1 - 13.01.2014, 18:40
Re: Recover a value[mysql] - by sammp - 13.01.2014, 22:24
Re: Recover a value[mysql] - by anou1 - 13.01.2014, 22:37
Re: Recover a value[mysql] - by anou1 - 14.01.2014, 09:46
Re: Recover a value[mysql] - by sammp - 14.01.2014, 18:10
Re : Recover a value[mysql] - by anou1 - 14.01.2014, 20:46

Forum Jump:


Users browsing this thread: 1 Guest(s)