RevCMS MySQL query

[DutchenL]

Hey

I want to give someone after payment the badge VIP in the table `user_badges`
How can I do this?

It should be something like this but doesn't work:

   mysql_query ("UPDATE user_badges SET badge_id = VIP  WHERE id = '".mysql_real_escape_string($_GET['userid'])."'") or die (mysql_error());

[MentaL]

[Dann Marchelo]

Why UPDATE you're not changing anything use INSERT INTO.

[DutchenL]

So like this?

mysql_query ("INSERT INTO user_badges SET badge_id = VIP WHERE id = '".mysql_real_escape_string($_GET['userid'])."'") or die (mysql_error());

[GrateZ4]

mysql_query("INSERT INTO user_badges (user_id, badge_id) VALUES ('". $_SESSION['user']['id'] ."',VIP)");

[DutchenL]

mysql_query("INSERT INTO user_badges (user_id, badge_id) VALUES ('". $_SESSION['user']['id'] ."',VIP)");

Doesnt work + unsafe

[GrateZ4]

Doesnt work + unsafe

Works fine for me woopwoop

[DutchenL]

but can you fix mine?