Revcms mysql querys

[jasjj]

Hi,

Anyone know how i get mysql query working for a user? like:

<?php$con = mysql_connect("localhost","loginname","password");mysql_select_db("dbname");if (!$con)  {  die('Could not connect: ' . mysql_error());  }
 
 
$query = "UPDATE users SET rank = 3, credits = credits + '1000000', activity_points = activity_points + '200000' WHERE username = '" . $_POST['username'] . "'";mysql_query($query) or die (mysql_error());
 
mysql_close($con);?>
sometext...

it show the text but the query doesnt work