Database get error

[Badriansyah]

i am newbie, so i'm sorry for silly question..

i want to insert data to my database.

this is my syntax 

$pDOStatement = $database->query("INSERT INTO questions (ID_USER,TIME_Q, QUESTION) VALUES (1,NOW(), $pertanyaan)");

for $pertanyaan is my variable which string.

but, i get error (in attacment)

please help. thx

[pwired]

https://processwire.com/api/ref/database/query/

Usually missing a closing parenthesis or a backtick or using a keyword in SQL that you have to quote

 

 

 

[Doug G]

My guess is your QUESTION column is a text column, if so you need to add apostrophes ( ' ) around $pertanyaan in your sql