February 12, 2011 
Definition:
function maybe_drop_column($table_name, $column_name, $drop_ddl) {}
Drop column from database table, if it exists.
Parameters
- string $table_name: Table name
- string $column_name: Column name
- string $drop_ddl: SQL statement to drop column.
Return values
returns:False on failure, true on success or doesn’t exist.
Source code
function maybe_drop_column($table_name, $column_name, $drop_ddl) {
global $wpdb;
foreach ($wpdb->get_col("DESC $table_name",0) as $column ) {
if ($column == $column_name) {
//found it try to drop it.
$wpdb->query($drop_ddl);
// we cannot directly tell that whether this succeeded!
foreach ($wpdb->get_col("DESC $table_name",0) as $column ) {
if ($column == $column_name) {
return false;
}
}
}
}
// else didn't find it
return true;
}
2333
A HitchHackers guide through WordPress 
No comments yet... Be the first to leave a reply!