[SOLVED] Changing value of a certain column to 0 on all rows

[DDRRE]

MySQL database name: ady_zofim
MySQL table name: ibf_members

Columns to change:

`deposited` int(16) NOT NULL default '0',
`auto_collect` tinyint(1) NOT NULL default '0',
`extra_interest` int(3) NOT NULL default '0',
`creditcard` int(3) NOT NULL default '0',
`points` int(11) NOT NULL default '10',

how can I change the value of these columns on all rows to 0?
(a PHP script would be nice :))

[exploo]

Allright, so you want to change all these columns to 0, on all rows.
This should be the query for that:

UPDATE ibf_members SET deposited=0, auto_collect=0, extra_interest=0, creditcard=0, points=0;