MySQL query didn't execute.

[Fratello]

Greetings.

My SQL isn't being executed at all.

mysql_query(mysqlDB, "INSERT INTO `test` (id, username) VALUES("0", 'testt');");

My connection (under onscriptload)

mysqlDB <- mysql_connect("**", "**", "**", "**");
   if( mysqlDB ) print( "[SERVER] Connection to mySQL database successful." );
   else print( "[SERVER] Connection to mySQL failed." );

I always get 'connection to mysql databse successful' message. And yes, I have table 'test' and database vcmp with all items inside it.

Thanks!

[Xmair]

Try changing:

Code Select Expand

mysql_query(mysqlDB,"INSERT INTO `test` (id, username) VALUES("0", 'testt');");to

Code Select Expand

mysql_query(mysqlDB,"INSERT INTO `test` (id, username) VALUES(0, 'testt');");

[Fratello]

Oh, I totally forgot about that one. Prototype version of id was actually a string instead of current (int). So I forgot to change it.

Thanks!