清除票数大于50的PHP脚本

Question

I only want to reset votes greater than 50, currently is resets every one

    <?
include('mysql_connect.php');
$query = "SELECT id, votes, callback FROM websites";
$result = mysql_query($query) OR die(mysql_error());
$query = "UPDATE websites SET votes = 0";
$result = mysql_query($query) OR die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);


echo ('Database has been cleaned with a tissue.');
?>

Im used to coding Java so im not sure if i can use this

$query = "UPDATE websites WHERE votes >= 50 SET votes = 0";

Thanks for your help

Answer 1

you're close. Do this instead.

$query = "UPDATE websites SET votes = 0 WHERE votes >= 50 ";

Also mysql_* functions are deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.