Mysql Problem
#3

Quote:
Originally Posted by Gireada
Посмотреть сообщение
[10:11:40] ProcessQueryThread(SendQuery) - Error will be triggered to OnQueryError().
First of all, for strings use:
pawn Код:
'%s'
instead of just:
pawn Код:
%s
Debug it.
pawn Код:
new query[300];
    format(query, sizeof(query), "UPDATE `cars` SET `propietar` = %s, `model` = %d, `numar` = %s, `pret` = %d, `culoare1` = %d, `culoare2` = %d, `spawnx` = %f, `spawny` = %f, `spawnz` = %f, `spawna` = %f, `cumparata` = %d, `donata` = %d, `inchisa` = %d \
    WHERE `id` = '%d'"
,
        VehInfo[vehicleid][Propietar],
        VehInfo[vehicleid][Model],
        VehInfo[vehicleid][Numar],
        VehInfo[vehicleid][Pret],
        VehInfo[vehicleid][Culoare1],
        VehInfo[vehicleid][Culoare2],
        VehInfo[vehicleid][Spawnx],
        VehInfo[vehicleid][Spawny],
        VehInfo[vehicleid][Spawnz],
        VehInfo[vehicleid][Spawna],
        VehInfo[vehicleid][Cumparata],
        VehInfo[vehicleid][Donata],
        VehInfo[vehicleid][Lock],
        VehInfo[vehicleid][ID]);
print(query); // Let's see what it prints.
And then go to phpMyAdmin and execute the query was printed. It will tell you the error was occured. Last,
show us the results.
Reply


Messages In This Thread
Mysql Problem - by Gireada - 09.09.2013, 10:53
Re: Mysql Problem - by iJumbo - 09.09.2013, 10:58
Re: Mysql Problem - by Konstantinos - 09.09.2013, 11:00
Re: Mysql Problem - by Gireada - 09.09.2013, 11:45

Forum Jump:


Users browsing this thread: 1 Guest(s)