Quick Search:
 
 PHP Code: Toggle a column bit regardless of state Jump to:  
Category: >> PHP Code >> Toggle a column bit regardless of state  

<< 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
» Toggle a column bit regardless of state
» FUNCTIONS: IF statement
» TABLE: Using Select Statement With Data
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement

Comment: (none)

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";


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org