making a mass modification to all users?

[chris frolic]

I'll preface this by saying I know very little about mysql.

I'd like to change a field that is in my database (regarding a vbPortal setting hack) from a 1 to a 0.

Under the user table, there's a field called "showleftcolumn"

I'd like to change that to 0 for all users. I'm sure this is easy but i just dont have a clue.

thanks.

[scoutt]

after you connect to the DB use this.

$sql_update = "update usertable set showleftcolumn='0' ";

$result = mysql_query ($sql_update);

[chris frolic]

Thanks for the response. But where exactly would I type this in?

[chris frolic]

ah, figured it out. thanks, it's worked.