Really simple error, I just can't see it

[Jonteh]

The code that's wrong is :

dbquery("INSERT INTO cms_alerts (alert,author) VALUES ('"' .clean($_POST['hatext']). '", "'.USER_NAME.'"')");

And the error is :

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\xampp\htdocs\manage\pages\ha.php on line 21

Can you please help me? It's been pissing me off for ages, and i'm too tired to think properly.

 

[EliteGM]

dbquery("INSERT INTO `cms_alerts` (alert, author) VALUES ('". clean($_POST['hatext']) .", ". USER_NAME ."')");

Try that.

 

[Jonteh]

Sent a message to the server: :>

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 ':>, USER_NAME)' at line 1

 

[EliteGM]

Sorry sorry sorry that was bad of me =P

dbquery("INSERT INTO `cms_alerts` (alert, author) VALUES ('". clean($_POST['hatext']) ."', '". USER_NAME ."')");

 

[Jonteh]

Unknown column 'test' in 'field list'

o.o

 

[EliteGM]

That's something in your other code I'm afraid

 

[Jonteh]

Are you sure? I can get it to insert the hatext fine but when it comes to the username..

Edit -

Was the hatext, just did a variable to get it to work

Thanks for the help!

 

[EliteGM]

Where do you define USER_NAME?
Are you sure you're not using a normal variable?

 

[sachav]

Unknown column 'test' in 'field list'

o.o

Test is not a column in your field list, the query probably ran fine.

 

[Jonteh]

USER_NAME is the users session username
It works now, don't worry.

Thanks again