Why this code is not inserting the data on my SQL database

[Sebas_1]

$query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id')
VALUES ('sadj', 'qwesad', 'sadqwdqw', '0','sadsad', 'sadasdsad''4')";

$resultprof = $this -> conn -> query($query);

votes and user_id are INT columns, and user_id is a foreign key.

Making this insert on mySQL directly it works perfectly, but on my PHP the "success" is false....

[Reverend Jim]

Are you sure you don't want 'sadasdsad','4' instead of 'sadasdsad''4'?

[Dani]

Does just this specific query fail? Perhaps there is something wrong with the connection?

[AB_1]

$query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id')
VALUES ('sadj', 'qwesad', 'sadqwdqw', '0','sadsad', 'sadasdsad''4')";

$query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id')
VALUES ('sadj', 'qwesad', 'sadqwdqw', '0', 'sadsad', 'sadasdsad', '4')";

Try above query

[Reverend Jim]

The OP replied by PM (a no no) that he had mistyped the table name.

[princejijk]

$query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id')
VALUES ('sadj', 'qwesad', 'sadqwdqw', '0','sadsad', 'sadasdsad','4')";

$resultprof = $this -> conn -> query($query);