[juraska]

error

Код:

[22:11:01] >> mysql_query( Connection handle: 0 )

[22:11:01] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[22:11:01] >> mysql_query( Connection handle: 0 )

[22:11:01] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

my code

Код:

new q[128];
	format(q, 200, "INSERT INTO `businessdata` (`id`) VALUES (%d)", id);
	mysq_query(q);

[MP2]

pawn Код:

new q[64];
format(q, sizeof(q), "INSERT INTO `businessdata` (id) VALUES (%d)", id);
mysq_query(q);

Try that.

[juraska]

Same thing!
until this error everything is alright

[MP2]

It's mysql_query not mysq_query. I guess you corrected that already though.

I'm not sure.

[System64]

please show your mysql_connect if you have it?

[juraska]

there mysql_connection = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);

[Joe Staff]

Is that located under ongamemodeinit?

[juraska]

No, it's not. It's in end of script

[Joe Staff]

Needs to be in, or at least called from, OnGamemodeInit

[juraska]

Same again. okey, are one strage thing
When I load house with same way everything is fain
When I load business is sh**

business loading

Код:

    new q[64];
    format(q, sizeof(q), "INSERT INTO `businessdata` (id) VALUES (%d)", id);
    mysql_query(q);

Houses loading

Код:

new q[128];
	format(q, 200, "INSERT INTO `housedata` (`id`) VALUES (%d)", id);
	QUERY(q);