need some help with a MySQL Connection
#2

pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername));
mysql_real_escape(playername, playername);
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1) PlayerInfo[playerid][Registered] = 1;
else PlayerInfo[playerid][Registered] = 0;
mysql_free_result();
That's how you should do it.
Reply


Messages In This Thread
need some help with a MySQL Connection - by TheChaoz - 06.03.2010, 03:27
Re: need some help with a MySQL Connection - by Miguel - 06.03.2010, 04:06
Re: need some help with a MySQL Connection - by TheChaoz - 06.03.2010, 04:20
Re: need some help with a MySQL Connection - by Miguel - 06.03.2010, 04:25
Re: need some help with a MySQL Connection - by TheChaoz - 06.03.2010, 04:26
Re: need some help with a MySQL Connection - by Miguel - 06.03.2010, 04:28
Re: need some help with a MySQL Connection - by TheChaoz - 06.03.2010, 04:34
Re: need some help with a MySQL Connection - by Miguel - 06.03.2010, 04:43
Re: need some help with a MySQL Connection - by TheChaoz - 06.03.2010, 04:57
Re: need some help with a MySQL Connection - by Miguel - 06.03.2010, 05:05

Forum Jump:


Users browsing this thread: 2 Guest(s)