Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002

    Need a little MySQL/phpMyAdmin help

    There is a setting "user_viewemail" that is either "0" or "1". It is within the "phpbb_users" table. I want to change user_viewemail to 0 for all records in the table. Is there a mysql command I can enter within phpMyAdmin to accomplish this? I think there is, but my grasp of MySQL is rather limited.

    Here's a screenshot of the setting in particular within phpMyAdmin:

    Thanks for your help!

  2. #2
    Join Date
    Sep 2002
    Dallas, TX
    The following SQL will set user_viewemail to 1 for all records in the phpbb_users table:

    UPDATE phpbb_users
    SET user_viewemail = 1
    justin 'at'
    Shared Unix Hosting

  3. #3
    Join Date
    Mar 2002
    Cool. As simple as that, huh? Thanks. I had thought I needed 'tinyint' somewhere in there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts