CoderZone.org

Category: >> PHP Code >> Toggle a column bit regardless of state Bookmark and Share

<< lastnext >>

Snippet Name: Toggle a column bit regardless of state

Description: Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.

Also see:
» Array of all US states
» FUNCTIONS: IF statement
» TABLE - Using Select Statement Wi...
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» UPDATE: Update from a SELECT state...
» Inserting into SELECT statement

Comment: (none)

Author: CoderZone
Language: PHP
Highlight Mode: PHP
Last Modified: March 16th, 2009

// simple one-liner toggles the column 'ban_enabled' bit regardless of state
$toggle_sql = "UPDATE some_table SET ban_enabled = 1 - ban_enabled WHERE item_id = '$bid' LIMIT 1";
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 41