What's wrong with this (mysql)?
#1

pawn Код:
format(query,sizeof(query),"UPDATE `PlayerDealership` SET `Owner` = '%s' WHERE `Owner` = '%s'",name,Nam);
mysql_query(query);
When i use it on my phpmyadmin it works probably. But on the server i get this from debug

Код:
[05:20:22] CMySQLHandler::Query(UPDATE `PlayerDealership` SET `Owner` = 'Yoloswag' WHERE `Owner` = 'Tan') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now)
[05:20:22] >> mysql_query( Connection handle: 1 )
Reply
#2

i don't know to use mysql in samp , but i know how to use mysql in php

and your problem is that you are sending a query while the last one is still "active".

you have to call mysql_free_result ( is it implemented in mysql plugin ? )

if this is not the problem , i cannot help you much sorry


*EDIT*
seem like i was right

http://dev.mysql.com/doc/refman/5.0/...t-of-sync.html
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)