HELP MySQL - Printable Version

HELP MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: HELP MySQL (/showthread.php?tid=82102)

HELP MySQL - MiniYoda - 16.06.2009

Hello!,

I have a problem with this mysql request. The query is right, because I have tested it in php.
I have changed the query a lot, for example I have added an end token ";" ... but everytime my server crashes.

Maybe you can tell me my mistake, thanks!

I use a_sampmysql...

Код:

format(samp_mysql_query4, sizeof(samp_mysql_query4), "SELECT id FROM user WHERE name = '%s'",playrname);
samp_mysql_query(samp_mysql_query4);
samp_mysql_store_result();


if(samp_mysql_num_rows() != 0)
{            
	gPlayerAccount[playerid] = 1;
} else {
	gPlayerAccount[playerid] = 0;
}

samp_mysql_free_result();

Yes, I have defined mysql_query4...

THANK YOU... Greetings from Germany .. MY

Re: HELP MySQL - MenaceX^ - 16.06.2009

Debug it, it's hard to know by looking this code, it's probably failed to select from the mysql.

Re: HELP MySQL - MiniYoda - 16.06.2009

i have found the mistake -.- i am so stupid... no comment where the mistake was ..

.. this mistake is to stupid

i am sorry...

Re: HELP MySQL - MenaceX^ - 16.06.2009

Where was your mistake?