db_column_exists

Check if a column exists in the given table.

Parameters

$table: The name of the table.

$column: The name of the column.

Return value

TRUE if the column exists, and FALSE if the column does not exist.

Related topics

Database abstraction layer

Allow the use of different database servers using the same code base.

1 call to db_column_exists()

File

includes/database.mysql.inc, line 370

Database interface code for MySQL database servers.

Code

function db_column_exists($table, $column) {
  return (bool) db_fetch_object(db_query("SHOW COLUMNS FROM {" . db_escape_table($table) . "} LIKE '" . db_escape_table($column) . "'"));
}