Problema su Mysql

[Yuji]

Taigi,kuriau pernaują Gm,padariau registraciją pagal viena pamoka ir man mysql debug'e yra keletas klaidu

[20:45:40] >> mysql_query( Connection handle: 1 )

[20:45:40] CMySQLHandler::Query(SELECT * FROM `vartotojai` WHERE vardas = 'Kennet_Jordan') - Successfully executed.

[20:45:40] >> mysql_store_result( Connection handle: 1 )

[20:45:40] CMySQLHandler::StoreResult() - Result was stored.

[20:45:40] >> mysql_num_rows( Connection handle: 1 )

[20:45:40] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:45:40] >> mysql_free_result( Connection handle: 1 )

[20:45:40] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:45:43] >> mysql_query( Connection handle: 1 )

[20:45:43] CMySQLHandler::Query(INSERT INTO `vartotojai` (vardas,slaptazodis) VALUES ('Kennet_Jordan','123456)) - An error has occured. (Error ID: 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 ''123456)' at line 1)

[20:45:47] >> mysql_reconnect( Connection handle: 1 )

[20:45:47] CMySQLHandler::Disconnect() - Connection was closed.

[20:45:47] CMySQLHandler::Connect() - Connection was successful.

[20:45:47] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[20:45:47] >> mysql_query( Connection handle: 1 )

[20:45:47] CMySQLHandler::Query(UPDATE `vartotojai` SET pinigai ='5000', WHERE vardas ='Kennet_Jordan') - An error has occured. (Error ID: 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 'WHERE vardas ='Kennet_Jordan'' at line 1)

[20:46:27] >> mysql_query( Connection handle: 1 )

[20:46:27] CMySQLHandler::Query(SELECT * FROM `vartotojai` WHERE vardas = 'Kennet_Jordan') - Successfully executed.

[20:46:27] >> mysql_store_result( Connection handle: 1 )

[20:46:27] CMySQLHandler::StoreResult() - Result was stored.

[20:46:27] >> mysql_num_rows( Connection handle: 1 )

[20:46:27] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:46:27] >> mysql_free_result( Connection handle: 1 )

[20:46:27] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:46:32] >> mysql_query( Connection handle: 1 )

[20:46:32] CMySQLHandler::Query(INSERT INTO `vartotojai` (vardas,slaptazodis) VALUES ('Kennet_Jordan','1234568)) - An error has occured. (Error ID: 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 ''1234568)' at line 1)

[20:46:42] >> mysql_reconnect( Connection handle: 1 )

[20:46:42] CMySQLHandler::Disconnect() - Connection was closed.

[20:46:42] CMySQLHandler::Connect() - Connection was successful.

[20:46:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[20:46:42] >> mysql_query( Connection handle: 1 )

[20:46:42] CMySQLHandler::Query(UPDATE `vartotojai` SET pinigai ='5000', WHERE vardas ='Kennet_Jordan') - An error has occured. (Error ID: 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 'WHERE vardas ='Kennet_Jordan'' at line 1)

Kaip sutvarkit tokia klaidą?

[appleomax]

Nereikia kablelio prie WHERE

(UPDATE `vartotojai` SET pinigai ='5000' WHERE vardas ='Kennet_Jordan')

Praleidai kabutę prie skaičių

(INSERT INTO `vartotojai` (vardas,slaptazodis) VALUES ('Kennet_Jordan','1234568'))

[Yuji]

Susitvarkiau,dėkui už pagalba.