Need to check for a column in a table

[Dylanblitz]

Haven't tested it but this should work, just put it in your product xml install code and replace with the real variables.

PHP Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "TABLE_NAME ADD NEW_COLUMN mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER AN_EXISTING_COLUMN");

$column_query = $db->query_read("SHOW COLUMNS FROM " . TABLE_PREFIX . "TABLE_NAME LIKE 'OLD_COLUMN_NAME'");

while ($column_data = $db->fetch_array($column_query))
{
$db->query_write("UPDATE " . TABLE_PREFIX . "TABLE_NAME SET NEW_COLUMN = OLD_COLUMN_NAME");
}