$sql ="UPDATE ratings SET used_ips = 'NULL',total_value = '0',total_votes = '0' WHERE id = 'easeofusetemp'";
$query = mysql_query($sql);
but im not sure if i will have to run 4 individual queries as above or if it can be done in one query

if anyone can help
thanks
Luke

guelphdad

03-05-2009, 02:42 PM

Don't use 'NULL' inside quotes, that is a string and not an actual NULL value. Similarly you should not quote numeric values.

Lastly, since you are updating all values to the same thing then you can change your query to: