is my table updating script right?

[Jiraiya]

im not sure whats wrong with my updating script

 

 

 

 

 

$username = $_COOKIE['ID_my_site'];
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());
if($r = mysql_fetch_assoc($sql)) {
    $skill = $r['skill'];
    if($skill >= 5000000) {
        //$rank = Akatsuki;
        //Unless Akatsuki is a constant, it should be in quotes.
        $rank = 'Akatsuki';

$query = "UPDATE users rank = '$rank=Akatsuki";

[kpetsche20]

You are missing a where statement in your update query.

[Jiraiya]

i added a were script put it still dosent work

[mapleleaf]

$query = "UPDATE users SET rank = 'Akatsuki' WHERE id = 'whatever'";

 

Missing SET I think