[Help] SQL

[Stranger]

hello , i'm working on vehicle shop so

i'm trying to make when the vehicle get destroyed the color of the vehicle saved

on the sql when i do the UPDATE in the sql so

it shows on the database in the color's column the price of the vehicle at each one of the column

i've tried so many ways but not one of those ways works with me, so help

here is the code:

executeSQLQuery ("UPDATE `Vehs` SET `ColorR` = ?, `ColorG` = ?, `ColorB` = ?, `cost` = ? WHERE `Account` = ? AND `Model` = ?", r, g, b, cost, getPlayerAccount (source), id) 

i guess the problem only here so,

['LinKin]

What error does the debug output?

[Stranger]

nothing

[Anubhav]

  
executeSQLQuery ("UPDATE `Vehs` SET `ColorR` = ?, `ColorG` = ?, `ColorB` = ?, `cost` = ? WHERE `Account` = ? AND `Model` = ?", r, g, b, cost, tostring(getAccountName(getPlayerAccount (source))), id) 
  

['LinKin]

I see no error on that line, unless the variables you define aren't what you think they are.

Re-check them

[Stranger]

yea thanks, solved.

[Stranger]

but there is a problem, why in the database if i change the colors of the vehicle, like: 255, 0, 0

it shows on the database like this 3, 0, 0, and if i change it to 0, 255, 0 it shows like: 65, 0, 0

i don't know why !!!

['LinKin]

What are the columns' types that you defined when you created the table?

[Stranger]

TEXT

['LinKin]

Well, if they are TEXT, then you need to do somethig like:

executeSQLQuery ("UPDATE `Vehs` SET `ColorR` = ?, `ColorG` = ?, `ColorB` = ?, `cost` = ? WHERE `Account` = ? AND `Model` = ?", tostring(r), tostring(g), tostring(b), cost, getAccountName(getPlayerAccount (source)), id) 

EDIT:

You don't need tostring(getAccountName(getPlayerAccount (source))) because getAccountName returns a string by default.

Edited August 30, 2014 by Guest

[Anubhav]

yea thanks, solved.

No problem.