Add column if not exists

Question

Trying to add column with below function and when we going to plugin page it is adding column properly but than after that when visit plugin page taking long time and loads nothing.

 

function init_queries($tableslc){

 

$table = qa_db_add_table_prefix('users');

$col = "SELECT checking FROM ".$table;

 

if(!in_array($col, $tableslc)){

 

$insert_col = "ALTER TABLE ".$table." ADD checking DATETIME NOT NULL";

 

qa_db_query_sub($insert_col);

 

}

 

}

 

Answer 1

Use SHOW COLUMNS FROM table to get the list of columns in a table.

Comments

Wonderful! thanks a lot.