Solved Insert something to database

[pioncz]

Hello,
I have this script on globalevent. I want to show on site when some raid appears, so i did this script after evert raid:
db.executeQuery("INSERT INTO newsy (data,tresc,typ) VALUES (CURRENT_TIMESTAMP," .. rando .. ",1)")
When its used i have this error: [31/07/2011 13:07:29] mysql_real_query(): INSERT INTO newsy (data,tresc,typ) VALUES (CURRENT_TIMESTAMP,Barbarian,1) - MYSQL ERROR: Nieznana kolumna 'Barbarian' w field list (1054)

When i do it on phpMyAdmin i dont have that error, why is that?

 

[tompan]

Nieznana kolumna.. but i think that you are missing table Barbarian.

 

[pioncz]

I tought Barbarian should be a value, not a table. Where i can put value Barbarian?

 

[Wymietek]

nope u should do it that way (barbarian is a string)

(CURRENT_TIMESTAMP,'Barbarian',1)

not

(CURRENT_TIMESTAMP,Barbarian,1)

 

[Itutorial]

db.executeQuery("INSERT INTO `newsy` (`data`,`tresc`,`typ`) VALUES (CURRENT_TIMESTAMP," .. rando .. ",1);")

 

[Tarek]

db.executeQuery("INSERT INTO `newsy` (`data`,`tresc`,`typ`) VALUES (CURRENT_TIMESTAMP," .. rando .. ",1);")

This post is from 2011....

 

[Itutorial]

"Its not too late, its never to late."

 

[Lakkir]

Indeed, it's never too late, I adapt the sql query to something that was usefull for my server, thanks!