DB function failed with error number 1064

[areavirtual]

Hi,

  before posting this Thread i've looked in the old forum, but i couldn't find what i was looking for.

my sql sintax is giving me this error:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10, none, , wqeqwe, wqeqewq, weqeqwe, , )' at line 1 SQL=INSERT INTO jos_encomendas (`id`, `campo_pagamento`, `pub`, `tag`, `contrato`, `jogos`, `tr`, `slots`, `slotsts`, `pagar`, `pass_admin`, `nome_clan`, `nome_servidor`, `nome`, `emai`) VALUES (null, 1, 0.00, 0, 1, 3.00, , 10, none, , wqeqwe, wqeqewq, weqeqwe, , )

i'm new with mysql and i don't know why this is happening, i'm using the piece of the rock an roll sample, with the necessary changes formy table jos_encomendas.

if any one could help.

Thanks

Bruno

[boldee]

Hi Bruno
By the looks of it its you syntax exactly as the error says if you look closley you will see you have 2 commas togeather in a few places im pretty sure thats why you get this error.

[galaxyboss]

Hi

i had the same problem, yopu have to check ur Mysql table stracture:
if u have INT,TININT : you have to use the insert like : insert...value($value1,$value2,...)
and if you have text or varchar and I think datetime you have to use '$value1':
inser ...value('$value1',$valueINT,'$valuetext',.......)

[areavirtual]

Hi,

thanks for both, the problem was in the query.

Best regards

Bruno