Solved Loop issues.

[Nothxbye]

Hello,

I've got loop:

for i = 1, 4 do 
  print(i)
  db.query("UPDATE `player_items` SET `serialId` = "..i.." WHERE `serialId` = 0")
end

"Print" returns:
1
2
3
4

But the "db.query" in database returns
1
1
1
1

Why it happens?

 

[Evil Hero]

Do you mean you tried to print(db.query("..."))?
because if a query succeeds then it returns 1 (true) if it fails it returns 0 (false)

 

[Acedayz]

Most likely because your 'serialId' column is a boolean and needs to be changed to an integer.

 

[Nothxbye]

Do you mean you tried to print(db.query("..."))?
because if a query succeeds then it returns 1 (true) if it fails it returns 0 (false)

I'm not talking about true of false i know it returns true if i print(db.query("..."))

Bassicaly i need result like this one:

But the result is 1,1,1,1

Most likely because your 'serialId' column is a boolean and needs to be changed to an integer.

I think it's int not bolean column:
Look

 

[Acedayz]

Set it to an int(11).

 

[Nothxbye]

Set it to an int(11).

Still same. Also i noticed something strange. Even if i exute this loop once it setting value 1 to more than 4 queries as is in loop:

function onSay(cid, words, param)
   for i = 1, 4 do 
     print(i)
      db.query("UPDATE `player_items` SET `serialId` = "..i.." WHERE `serialId` = 0")
   end
end

print shows: 1,2,3,4 in console but in database i have 1,1,1,1,1,1....

What i doing wrong?

 

[Nothxbye]

This was my problem "LIMIT 1;" at query ending

   for i = 1, 4 do
     print(i)
      db.query("UPDATE `player_items` SET `serialId` = "..i.." WHERE `serialId` = 0 LIMIT 1;")
   end

Problem solved.