Problem on assignment
#4

Instead of making a new topic for the same system I'll post my trouble here...
I'm trying to set the plate with the SQLid of the vehicle, I got this 2 queries:
pawn Код:
//Called on the command to create the Vehicle
format(query, sizeof(query), "INSERT INTO car(Owner, Model, Price, Col1, Col2, cLock, cX, cY, cZ, cA, tID) VALUES ('%s', '%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f', '%d')",
                                        RUS(playerid), //Name w/out '_'
                                        model,
                                        price,
                                        Car[id][cCol1],
                                        Car[id][cCol2],
                                        Car[id][cLock],
                                        Car[id][cX],
                                        Car[id][cY],
                                        Car[id][cZ],
                                        Car[id][cA],
                                        id);
        print(query); // DEBUG
        mysql_function_query(connection, query, false, "", "");
And it works, after that, I do:
pawn Код:
//Called when you press ENTER while chosing the colors of vehicle
new query[1024];
                format(query, sizeof(query), "SELECT * FROM car WHERE tID = '%s' LIMIT 1", GetPlayerVehicleID(playerid));
                mysql_function_query(connection, query, true, "SetPlate", "dd", playerid, GetPlayerVehicleID(playerid));
But it return 0 rows IG, while if I do the same code, copied by the print on console, on Phpmyadmin it will show the car...
What can I do?
Reply


Messages In This Thread
Problem on assignment - by Sk1lleD - 22.12.2013, 15:52
Re: Problem on assignment - by Konstantinos - 22.12.2013, 15:57
Re: Problem on assignment - by Sk1lleD - 22.12.2013, 16:01
Re: Problem on assignment - by Sk1lleD - 24.12.2013, 10:38
Re: Problem on assignment - by Konstantinos - 24.12.2013, 10:57
Re: Problem on assignment - by Sk1lleD - 24.12.2013, 11:12

Forum Jump:


Users browsing this thread: 1 Guest(s)