This is quite a simply query but i've just never come accross it before. I was to update 2 columns to blank within a table through PHP but want to use just one query. The one I tried was
"UPDATE $thismonthresults SET round1 = null AND SET round2 = null"
It's not working but i'm not sure how to null both column round1 and round2
Thanks
Ian