Mysql help - Query problem
#1

Hello everyone.

I've scripted a register system in mysql, and this is the first time i have this problem.
i have
format(query, sizeof(query), "INSERT INTO blabla", parameters);
and its alright. I've debugged it, and the line is okay. But it doesnt insert it into the database?
Anyone else had that problem?
Reply
#2

Have you verified the query would execute properly if executed under another platform (for example, running the query through PHP?).

If not, please could you paste the query here, or try that?
Reply
#3

If you're using G-sTyLeZzZ MySQL plugin (And you should), use MYSQL_DEBUG 1 and check the log it generates
Reply
#4

Use this https://sampwiki.blast.hk/wiki/MySQL#mysql_debug if you are using GsTyLeZzZ plugin like Lenny said and post the script and error here.
Reply
#5

Sorry i dont answer before now, but there doesnt show up any file when i debug?
I have mysql_debug(1); then (0); after
Reply
#6

*bumb, please help
Reply
#7

Take out
pawn Код:
mysql_debug(0);
And leave

pawn Код:
mysql_debug(1);
Reply
#8

Alright, here it is.

Код:
[17:03:06]  

[17:03:06] ---------------------------

[17:03:06] MySQL Debugging activated (10/09/10)

[17:03:06] ---------------------------

[17:03:06]  

[17:03:06] >> mysql_query( Connection handle: 1 )

[17:03:06] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[17:03:06] >> mysql_query( Connection handle: 1 )

[17:03:06] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[17:03:06] >> mysql_store_result( Connection handle: 1 )

[17:03:06] >> mysql_store_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).

[17:03:06] >> mysql_num_rows( Connection handle: 1 )

[17:03:06] >> mysql_num_rows() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
Reply
#9

Connect to the database.
Reply
#10

Lol, how could i forget? Thanks
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)