update not working

[almightyegg]

$update = mysql_query("UPDATE clutch (rank1, rank2, rank3, rank4, rank5, rank6, rank7, rank8, rank9, rank10, rank11, rank12, rank13, rank14, rank15, 
rank1color, rank2color, rank3color, rank4color, rank5color, rank6color, rank7color, rank8color, rank9color, rank10color, rank11color, rank12color, rank13color, rank14color, rank15color)
VALUES('$rank1', '$rank2', '$rank3', '$rank4', '$rank5', '$rank6', '$rank7', '$rank8', '$rank9', '$rank10', '$rank11', '$rank12', '$rank13', '$rank14', '$rank15', 
'$rank1color', '$rank2color', '$rank3color', '$rank4color', '$rank5color', '$rank6color', '$rank7color', '$rank8color', '$rank9color', '$rank10color', '$rank11color', '$rank12color', '$rank13color', '$rank14color', '$rank15color')
WHERE id = '{$clutch['id']}'");

 

It shows no error but when doing:

if(!$update){

echo "An error occured during the update process.";

}else{

echo "Ranks have been updated successfully.";

}

 

it shows: An error occured during the update process.

 

[Caesar]

Your update syntax should look something like:

 

<?php

  $db->connect();
  $db->query("UPDATE table SET field='$value', field2='$value2', field3='$value3' WHERE id='$id'");
  $db->close();

?>

[PC Nerd]

try

 

$Query = mysqli_query() or die ( mysqli_error());

 

check the syntax, im not 100% sure